Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. Date arithmetic operations require complete dates
mysql>
mysql> SELECT DATE_ADD('2006-07-00', INTERVAL 1 DAY);
+----------------------------------------+
| DATE_ADD('2006-07-00', INTERVAL 1 DAY) |
+----------------------------------------+
| NULL                                   |
+----------------------------------------+
1 row in set, 1 warning (0.00 sec)
mysql>