ADDTIME
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
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 |
+---------------------------------+
Last modified: May 31, 2023