sql 时间函数汇总

select start_time
,year(start_time)
,month(start_time)
,substr(start_time,1,7) -- 用来切片取月份
,datediff(submit_time,start_time) -- 用最大的时间-最小的时间来求日期的差
,TIMESTAMPDIFF(second,start_time,submit_time) -- 计算时间差，分钟，秒差 timestampdiff
,timestampdiff(minute,start_time,submit_time)
,unix_timestamp(submit_time) - unix_timestamp(start_time) as "秒" -- 用时间戳相减后得到秒，unix_timestamp
from exam_record 
where submit_time is not null