mysql时间字段加减

timediff 精确到毫秒单位

select timediff(end_ts,start_ts),substring(timediff(end_ts,start_ts),1,5),start_ts,end_ts from rest_serv_audit;

datediff

select datediff('2008-09-08', '2008-08-08'); 

to_days

select TO_DAYS('2008-09-08')-TO_DAYS('2008-08-08');

timestampdiff

select timestampdiff(day,'2008-08-08','2008-09-08');

select timestampdiff(hour,'2008-08-08','2008-09-08');

select timestampdiff(second,'2008-08-08','2008-09-08');