Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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)