ADDTIME(expr1,expr2) : ADDTIME : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » ADDTIME »

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>