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