TIMEDIFF(expr1,expr2) returns expr1 ¡§C expr2 expressed as a time value. : TIMEDIFF « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. TIMEDIFF
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)








14.44.TIMEDIFF
14.44.1.TIMEDIFF(expr1,expr2) returns expr1 ¡§C expr2 expressed as a time value.
14.44.2.SELECT TIMEDIFF('1997-12-31 23:59:59.000001', '1997-12-30 01:01:01.000002');