TIMEDIFF(expr1,expr2) returns expr1 ? expr2 expressed as a time value. : TIMEDIFF : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » TIMEDIFF »

TIMEDIFF(expr1,expr2) returns expr1 ? 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)