Syntax
PERIOD_ADD(P,N)
Purpose
PERIOD_ADD() adds N months to the period P. P is in the YYMM or YYYYMM format.
The return value is in the YYYYMM format.
Note
The argument P cannot be a DATE type value.
Examples
obclient> SELECT PERIOD_ADD(200801,2);
+----------------------+
| PERIOD_ADD(200801,2) |
+----------------------+
| 200803 |
+----------------------+
1 row in set