Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT TIMEDIFF(1997-12-31 23

mysql> mysql> SELECT TIMEDIFF('1997-12-31 23:59:59.000001', '1997-12-30 01:01:01.000002'); +----------------------------------------------------------------------+ | TIMEDIFF('1997-12-31 23:59:59.000001', '1997-12-30 01:01:01.000002') | +----------------------------------------------------------------------+ | 46:58:57.999999                                                      | +----------------------------------------------------------------------+ 1 row in set (0.02 sec) mysql>