Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

TIMEDIFF(expr1,expr2) returns expr1 C expr2 expressed as a time value

mysql> mysql> SELECT TIMEDIFF('2000:01:01 00:00:00', '2000:01:01 00:00:00.000001'); +---------------------------------------------------------------+ | TIMEDIFF('2000:01:01 00:00:00', '2000:01:01 00:00:00.000001') | +---------------------------------------------------------------+ | -00:00:00.000001                                              | +---------------------------------------------------------------+ 1 row in set (0.01 sec)