Outdated Version

You are viewing an older version of this section. View current production version.

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