MySQL中TIMESTAMPDIFF和DATEDIFF函数的区别

TIMESTAMPDIFF：后面的时间减去前面的时间

select -- 时间相差不到24小时不算一天 TIMESTAMPDIFF(DAY,'2017-06-02 00:00:00','2017-06-03') day1, -- 1 TIMESTAMPDIFF(DAY,'2017-06-02 00:00:01','2017-06-03') day2, -- 0 TIMESTAMPDIFF(DAY,'2017-06-02 11:00:11','2017-06-03 11:00:11') day3, -- 1 TIMESTAMPDIFF(DAY,'2017-06-02 11:00:11','2017-06-03 14:00:11') day4, -- 1 TIMESTAMPDIFF(DAY,'2017-06-02 11:00:11','2017-06-03 10:00:11') day5 -- 0

DATEDIFF：前面的时间减去后面的时间

select -- 只取前面日期部分进行计算 DATEDIFF('2017-06-03','2017-06-02 00:00:00') day1, -- 1 DATEDIFF('2017-06-03','2017-06-02 00:00:01') day2, -- 1 DATEDIFF('2017-06-03 11:00:11','2017-06-02 11:00:11') day3, -- 1 DATEDIFF('2017-06-03 14:00:11','2017-06-02 11:00:11') day4, -- 1 DATEDIFF('2017-06-03 10:00:11','2017-06-02 11:00:11') day5 -- 1

在这里插入图片描述