1、获取两个时间之间的天数
select TIMESTAMPDIFF(DAY, '2020-03-20 23:59:00', '2020-03-25 00:00:00') as days;
2、获取 两个时间之间的月份
select TIMESTAMPDIFF(month, '2020-01-20 23:59:00', '2020-03-25 00:00:00') as months;
3、获取两个时间之间的 时 分 秒
时
select TIMESTAMPDIFF(HOUR, '2020-03-23 23:59:00', '2020-03-25 00:00:00') as hours;
分
select TIMESTAMPDIFF(minute, '2020-01-20 23:59:00', '2020-03-25 00:00:00') as diff;
秒
select TIMESTAMPDIFF(second, '2020-01-20 23:59:00', '2020-03-25 00:00:00') as diff;
年
select TIMESTAMPDIFF(year, '2020-01-20 23:59:00', '2021-03-25 00:00:00') as diff;