MySQL datediff returns wrong date

Question

I want to calculate the difference in days between two dates: select datediff('2024-03-31', '2019-04-01');

Return value1826Error. The correct date is 2191. I checked the documentation but don't understand why this is happening.

Answer 1

Appears to be valid for the date expression provided

mysql> select datediff('2024-03-31','2019-04-01');
+-------------------------------------+
| datediff('2024-03-31','2019-04-01') |
+-------------------------------------+
|                                1826 |
+-------------------------------------+

For 2191, add/subtract one year

mysql> select datediff('2025-03-31','2019-04-01');
+-------------------------------------+
| datediff('2025-03-31','2019-04-01') |
+-------------------------------------+
|                                2191 |
+-------------------------------------+