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. Returns NULL if expr1or expr2 is NULL.

Syntax

MYSQL Copy

SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');
'2008-01-02 01:01:01.000001'
SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
'03:00:01.999997'

Examples

Example

The return type of this function and of the SUBTIME() function is determined as follows:

MYSQL Copy

SELECT ADDTIME('2007-12-31 23:59:59.999999', '1 1:1:1.000002');
'2008-01-02 01:01:01.000001'
SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
'03:00:01.999997'