Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. If the resulting date has a day that is larger than the maximum day for the new month, the day is adjusted to the maxi
mysql>
mysql> SELECT DATE_ADD('1998-01-30', INTERVAL 1 MONTH);
+------------------------------------------+
| DATE_ADD('1998-01-30', INTERVAL 1 MONTH) |
+------------------------------------------+
| 1998-02-28                               |
+------------------------------------------+
1 row in set (0.00 sec)
mysql>