Mega Code Archive

 

Categories / MySQL / Date Time

 

Use the + and - operators to perform date interval addition and subtraction

mysql> mysql> SELECT CURDATE( ), CURDATE( ) + INTERVAL 1 YEAR; +------------+------------------------------+ | CURDATE( ) | CURDATE( ) + INTERVAL 1 YEAR | +------------+------------------------------+ | 2011-10-03 | 2012-10-03                   | +------------+------------------------------+ 1 row in set (0.00 sec) mysql> mysql>