Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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. 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>