PERIOD_ADD

Syntax

PERIOD_ADD(P,N)

Purpose

You can call this function to add N months to the time 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 (0.00 sec)