Syntax
TIMESTAMPADD(unit, interval_expr, date)
Purpose
The arithmetic calculation of date and time.
This function is similar to DATE_ADD, but the unit can only be one of the following units:
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