Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

ADD_MONTHS(x, y) gets the result of adding y months to x

If y is negative, y months are subtracted from x. The following example adds 13 months to January 1, 2005: SQL> SELECT ADD_MONTHS('01-JAN-2005', 13)   2  FROM dual; ADD_MONTH --------- 01-FEB-06 SQL>