SELECT SUBTIME('01:00:00.999999', '02:00:00.999998'); : SUBTIME « Date Time Functions « MySQL Tutorial






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








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