How to compare two date intervals in mysql
In order to solve the problem of how to compare two date intervals in mysql, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.
Number of days between one and two dates, using the datediff () function
Example:
Mysql > select datediff (now (), '20160401')
+-+
| | datediff (now (), '20160401') | |
+-+
| | 4 |
+-+
1 row in set (0.00 sec)
Second, the exact interval between two dates, using timediff
Mysql > select timediff (now (), '2016-04-04 18 purl 10 purl 10')
+-+
| | timediff (now (), '2016-04-04 18-15-10-10') |
+-+
| | 15:41:28 |
+-+
1 row in set (0.00 sec)
This is the answer to the question about how to compare the interval between two dates in mysql. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.
