MySQL Tutorial/Date Time Functions/SUBTIME

SELECT SUBTIME("01:00:00.999999", "02:00:00.999998");

   <source lang="sql">

mysql> mysql> mysql> SELECT SUBTIME("01:00:00.999999", "02:00:00.999998"); +-----------------------------------------------+ | SUBTIME("01:00:00.999999", "02:00:00.999998") | +-----------------------------------------------+ | -00:59:59.999999 | +-----------------------------------------------+ 1 row in set (0.00 sec)</source>

SUBTIME(expr1,expr2)

   <source lang="sql">

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)</source>