TIMESTAMPADD
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 interval of time to a date or datetime object
Syntax
TIMESTAMPADD ({YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MICROSECOND}, num, dateobj)
Arguments
-
num: the number of units to add.
Can be negative -
dateobj: a valid date, datetime, or parsable date string
Return Type
Time object.
Examples
SELECT TIMESTAMPADD(YEAR, 6, '2009-02-13 23:31:30');
+----------------------------------------------+
| TIMESTAMPADD(YEAR, 6, '2009-02-13 23:31:30') |
+----------------------------------------------+
| 2015-02-13 23:31:30 |
+----------------------------------------------+
Related Topics
Last modified: May 31, 2023