You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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

memsql> 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