MONTHS_ADD
months_addβ
descriptionβ
Syntaxβ
DATETIME MONTHS_ADD(DATETIME date, INT months)
Add the specified month from the date
The parameter date can be DATETIME or DATE, and the return type is consistent with that of the parameter date.
exampleβ
mysql> select months_add("2020-01-31 02:02:02", 1);
+--------------------------------------+
| months_add('2020-01-31 02:02:02', 1) |
+--------------------------------------+
| 2020-02-29 02:02:02 |
+--------------------------------------+
keywordsβ
MONTHS_ADD