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

1. MySQL Tutorial
2. Date Time Functions
3. SUBTIME

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)