TIMESTAMPDIFF

声明

TIMESTAMPDIFF(unit, date1, date2)

说明

以 unit 为单位返回两个日期时间的间隔。unit 只能为 DATE_ADD 中的独立单位。

示例

SELECT
   TIMESTAMPDIFF(SECOND, NOW(), '2011-01-01 11:11:11'),
   TIMESTAMPDIFF(DAY, '2011-01-01 11:11:11', NOW())
   \G
*************************** 1. row ***************************
TIMESTAMPDIFF(SECOND, NOW(), '2011-01-01 11:11:11'): -472114117
   TIMESTAMPDIFF(DAY, '2011-01-01 11:11:11', NOW()): 5464
1 row in set (0.001 sec)