Mega Code Archive

 

Categories / MySQL / Date Time

 

TIMESTAMPADD is like ADDDATE, but it uses a different syntax for specifying the interval

mysql> mysql> select TIMESTAMPADD(DAY, 5, '2005-12-31'); +------------------------------------+ | TIMESTAMPADD(DAY, 5, '2005-12-31') | +------------------------------------+ | 2006-01-05                         | +------------------------------------+ 1 row in set (0.00 sec)