MySQL Tutorial/Date Time Functions/ADDTIME
ADDTIME("01:00:00.999999", "02:00:00.999998");
<source lang="sql">
mysql> mysql> mysql> mysql> SELECT ADDTIME("01:00:00.999999", "02:00:00.999998"); +-----------------------------------------------+ | ADDTIME("01:00:00.999999", "02:00:00.999998") | +-----------------------------------------------+ | 03:00:01.999997 | +-----------------------------------------------+ 1 row in set (0.00 sec) mysql></source>
ADDTIME(expr1,expr2)
ADDTIME() adds expr2 to expr1 and returns the result.
expr1 is a time or datetime expression, and expr2 is a time expression.
<source lang="sql">
mysql> mysql> SELECT ADDTIME("1997-12-31 23:59:59.999999","1 1:1:1.000002"); +--------------------------------------------------------+ | ADDTIME("1997-12-31 23:59:59.999999","1 1:1:1.000002") | +--------------------------------------------------------+ | 1998-01-02 01:01:01.000001 | +--------------------------------------------------------+ 1 row in set (0.00 sec) mysql></source>