SUBTIME(expr1,expr2) : SUBTIME « Date Time Functions « MySQL Tutorial






mysql>
mysql> SELECT SUBTIME('1997-12-31 23:59:59.999999','1 1:1:1.000002');
+--------------------------------------------------------+
| SUBTIME('1997-12-31 23:59:59.999999','1 1:1:1.000002') |
+--------------------------------------------------------+
| 1997-12-30 22:58:58.999997                             |
+--------------------------------------------------------+
1 row in set (0.00 sec)








14.41.SUBTIME
14.41.1.SUBTIME(expr1,expr2)
14.41.2.SELECT SUBTIME('01:00:00.999999', '02:00:00.999998');