timediff

description

Syntax

TIME TIMEDIFF(DATETIME expr1, DATETIME expr2)

TIMEDIFF返回两个DATETIME之间的差值

TIMEDIFF函数返回表示为时间值的expr1 - expr2的结果，返回值为TIME类型

example

  1. mysql> SELECT TIMEDIFF(now(),utc_timestamp());
  2. +----------------------------------+
  3. | timediff(now(), utc_timestamp()) |
  4. +----------------------------------+
  5. | 08:00:00                         |
  6. +----------------------------------+
  8. mysql> SELECT TIMEDIFF('2019-07-11 16:59:30','2019-07-11 16:59:21');
  9. +--------------------------------------------------------+
  10. | timediff('2019-07-11 16:59:30', '2019-07-11 16:59:21') |
  11. +--------------------------------------------------------+
  12. | 00:00:09                                               |
  13. +--------------------------------------------------------+
  15. mysql> SELECT TIMEDIFF('2019-01-01 00:00:00', NULL);
  16. +---------------------------------------+
  17. | timediff('2019-01-01 00:00:00', NULL) |
  18. +---------------------------------------+
  19. | NULL                                  |
  20. +---------------------------------------+

keyword

  1. TIMEDIFF