timediff

Description

Syntax

‘TIME TIMEDIFF (DATETIME expr1, DATETIME expr2)’

TIMEDIFF returns the difference between two DATETIMEs

The TIMEDIFF function returns the result of expr1 - expr2 expressed as a time value, with a return value of TIME type

The results are limited to TIME values ranging from - 838:59:59 to 838:59:59.

example

  1. mysql> SELECT TIMEDIFF(now(),utc_timestamp());
  2. +----------------------------------+
  3. (now (), utc -u timestamp ()124;
  4. +----------------------------------+
  5. | 08:00:00                         |
  6. +----------------------------------+
  8. mysql> SELECT TIMEDIFF('2019-07-11 16:59:30','2019-07-11 16:59:21');
  9. +--------------------------------------------------------+
  10. Time diff ('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','2009 -01 -01 00:00');
  16. +--------------------------------------------------------+
  17. Time diff ('2019 -01 -01 00:00','2009 -01 -01 00:00')
  18. +--------------------------------------------------------+
  19. | 838:59:59                                              |
  20. +--------------------------------------------------------+
  22. mysql > SELECT TIMEDIFF ('2019 -01 -01 00:00:00', NULL);
  23. +---------------------------------------+
  24. Time diff ('2019 -01 -01 00:00','NULL')
  25. +---------------------------------------+
  26. No. No. No.
  27. +---------------------------------------+

keyword TIMEDIFF