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
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