mysql计算时间差

来源:互联网 发布:oracle sql连接字符串 编辑:程序博客网 时间:2024/05/17 02:12
SELECT TIMESTAMPDIFF(SECOND, '2016-09-01 18:01:32', "2016-09-01 18:02:32")

输出结果:
60

TIMESTAMPDIFF(unit,datetime1,datetime2)

unit参数:
SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR

0 0