Declaration
TIMESTAMPADD(unit, interval_expr, date)
Description
Arithmetic operations on dates and times.
This function has the same purpose as DATE_ADD, but unit can only be one of the following:
MICROSECONDSECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Examples
obclient> SELECT
TIMESTAMPADD(DAY, -5, '2010-01-01 00:00:00'),
DATE_ADD('2010-01-01 00:00:00', INTERVAL -5 DAY)
\G
*************************** 1. row ***************************
TIMESTAMPADD(DAY, -5, '2010-01-01 00:00:00'): 2009-12-27 00:00:00
DATE_ADD('2010-01-01 00:00:00', INTERVAL -5 DAY): 2009-12-27 00:00:00
1 row in set