Date Time MySQL

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