TIMESTAMPADD

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. If dateobj is not a valid time, returns NULL.

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

Was this article helpful?