TIMESTAMPADD
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