Mega Code Archive

 

Categories / MySQL / Date Time

 

The following query shows two ways to determine the date for Christmas two years hence

mysql> mysql> SELECT CURDATE( ),     -> DATE_ADD(DATE_FORMAT(CURDATE( ),'%Y-12-25'),INTERVAL 2 YEAR)     -> AS method1,     -> DATE_FORMAT(DATE_ADD(CURDATE( ),INTERVAL 2 YEAR),'%Y-12-25')     -> AS method2; +------------+------------+------------+ | CURDATE( ) | method1    | method2    | +------------+------------+------------+ | 2011-10-03 | 2013-12-25 | 2013-12-25 | +------------+------------+------------+ 1 row in set (0.00 sec)