Mega Code Archive

 

Categories / MySQL / Date Time

 

ADDDATE (date, INTERVAL n i) adds n times the interval i to the starting date date

mysql> ADDDATE('2005-12-31', INTERVAL 3 DAY) returns '2006-01-03'. mysql> mysql> select ADDDATE('2005-12-31', INTERVAL 3 DAY); +---------------------------------------+ | ADDDATE('2005-12-31', INTERVAL 3 DAY) | +---------------------------------------+ | 2006-01-03                            | +---------------------------------------+ 1 row in set (0.00 sec)