You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

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

memsql> select ADDTIME("23:23:54", "02:45:07");
+---------------------------------+
| ADDTIME("23:23:54", "02:45:07") |
+---------------------------------+
| 26:09:01                        |
+---------------------------------+