Mega Code Archive

 

Categories / MySQL / Date Time

 

Adding a Temporal Interval to a Date

mysql> mysql> SELECT CURDATE( ), DATE_ADD(CURDATE( ),INTERVAL 3 DAY); +------------+-------------------------------------+ | CURDATE( ) | DATE_ADD(CURDATE( ),INTERVAL 3 DAY) | +------------+-------------------------------------+ | 2011-10-03 | 2011-10-06                          | +------------+-------------------------------------+ 1 row in set (0.00 sec) mysql>