1 DATEDIFF: DATEDIFF() 函数返回两个日期之间的天数。
SQL语句的写法:
select datediff('2020-5-1 09:00:00', '2020-5-8 07:00:00');
返回结果为2
2 TIMESTAMPDIFF: 可以进行参数设置,精确到天(DAY)、小时(HOUR),分钟(MINUTE)和秒(SECOND)
SQL写法:
求两者之间的天数
select TIMESTAMPDIFF(DAY, '2020-5-1 09:00:00', '2020-5-8 07:00:00')
求两者之间的小时
select TIMESTAMPDIFF(HOUR, '2020-5-1 09:00:00', '2020-5-8 07:00:00')
求两者之间的分钟
select TIMESTAMPDIFF(MINUTE, '2020-5-1 09:00:00', '2020-5-8 07:00:00')
求两者之间的秒
select TIMESTAMPDIFF(SECOND, '2020-5-1 09:00:00', '2020-5-8 07:00:00')
TIMESTAMPDIFF比 DATEDIFF更常用