select DATEDIFF('2022-03-30','2022-03-1') as 相差天数
select TIMEDIFF('2022-03-30 18:00:00','2022-03-30 16:03:11') as 相差时分秒
参数1 减 参数2 = 差值
select DATEDIFF('2022-03-30','2022-03-1') as 相差天数
select TIMEDIFF('2022-03-30 18:00:00','2022-03-30 16:03:11') as 相差时分秒
参数1 减 参数2 = 差值