84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
I want to calculate the difference in days between two dates:select datediff('2024-03-31', '2019-04-01');
select datediff('2024-03-31', '2019-04-01');
Return value1826Error. The correct date is2191. I checked the documentation but don't understand why this is happening.
1826
2191
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 | +-------------------------------------+
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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 | +-------------------------------------+