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.
Adds the given interval of time to a date or datetime object
TIMESTAMPADD ({YEAR | QUARTER | MONTH | WEEK | DAY | HOUR | MINUTE | SECOND | MICROSECOND}, num, dateobj)
Time object. If dateobj is not a valid time, returns NULL.
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