MySQL DATEDIFF() function also works with date and time values, but it ignores time values. Therefore, even if we include the time value in the DATEDIFF() function, MySQL will ignore the time value and return the difference between the dates in days.
mysql> Select DATEDIFF('2018-10-22 04:05:36','2017-10-22 03:05:45'); +-------------------------------------------------------+ | DATEDIFF('2018-10-22 04:05:36','2017-10-22 03:05:45') | +-------------------------------------------------------+ | 365 | +-------------------------------------------------------+ 1 row in set (0.00 sec) mysql> Select DATEDIFF('2017-10-22 04:05:36','2017-10-22 03:05:45'); +-------------------------------------------------------+ | DATEDIFF('2017-10-22 04:05:36','2017-10-22 03:05:45') | +-------------------------------------------------------+ | 0 | +-------------------------------------------------------+ 1 row in set (0.00 sec)
The above query shows that the DATEDIFF() function ignores time values when calculating the difference between dates.
The above is the detailed content of What will MySQL return if we include time components and date components in the parameters of the DATEDIFF() function?. For more information, please follow other related articles on the PHP Chinese website!
The difference between article tag and section tag
emule server link
How to get Douyin Xiaohuoren
Introduction to javascript special effects code
What to do if the remote desktop cannot connect
What are the office software
The difference between JD.com's self-operated flagship store and its official flagship store
How to buy and sell Bitcoin in China
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
