ADDTIME
Adds the given time object to a time or datetime object.
Syntax
ADDTIME (dateobj, timeobj)
Arguments
dateobj: a valid datetime, time, or parsable datetime string
timeobj: a valid time, or parsable time string.
Return Type
Datetime or time object.
Examples
SELECT ADDTIME("2010-04-02 01:23:54", "02:45:07");
+--------------------------------------------+ | ADDTIME("2010-04-02 01:23:54", "02:45:07") | +--------------------------------------------+ | 2010-04-02 04:09:01 | +--------------------------------------------+
SELECT ADDTIME("23:23:54", "02:45:07");
+---------------------------------+ | ADDTIME("23:23:54", "02:45:07") | +---------------------------------+ | 26:09:01 | +---------------------------------+