〇、背景
直接计算会报错
一、日期之差
1、MySQL
TIMESTAMPDIFF(SECOND,start_time,submit_time)/60 AS use_time
2、SQLServer
select datediff(d,'2020-02-24 20:59:00','2020-02-25 20:00:00')
3、Pgsql
select date_part('day','2020-02-25 20:00:00'::TIMESTAMP-'2020-02-24 20:59:00')