Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
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 |
+---------------------------------+
