Declaration
SUBTIME(expr1,expr2)
Description
Returns the difference between the time or datetime expression expr1 and the time expression expr2. The format of the return value is consistent with that of expr1.
Examples
obclient> SELECT SUBTIME('2021-07-14 19:12:59.999999','1 1:1:1.000002');
+--------------------------------------------------------+
| SUBTIME('2021-07-14 19:12:59.999999','1 1:1:1.000002') |
+--------------------------------------------------------+
| 2021-07-13 18:11:58.999997 |
+--------------------------------------------------------+
1 row in set