Syntax
SUBTIME(expr1,expr2)
Purpose
You can call this function to return the difference between the time or datetime expression expr1 and the time expression expr2. The format of the return value is the same as 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 (0.01 sec)