PERIOD_ADD(P,N) adds N months to period P (in the format YYMM or YYYYMM). : PERIOD_ADD « Date Time Functions « MySQL Tutorial

1. MySQL Tutorial
2. Date Time Functions
3. PERIOD_ADD

Returns a value in the format YYYYMM.

The period argument P is not a date value.

mysql>
mysql> SELECT PERIOD_ADD(9803,2);
+--------------------+
| PERIOD_ADD(9803,2) |
+--------------------+
|             199805 |
+--------------------+
1 row in set (0.00 sec)

mysql>
mysql>