ADD_MONTHS – Oracle SQL Function

ADD_MONTHS returns a DATE which is argument1 plus num, or number of months.

The argument1 can be a DATE or any type that can be implicitly converted to a DATE.

The num argument can be a NUMBER, or any type that can be implicitly converted to a NUMBER.

Specifying a negative number for the num argument will move the date backwards in time.

Syntax:

ADD_MONTHS(argument1, num);

Example:

SELECT TO_CHAR(ADD_MONTHS(’12-OCT-04′,2)) AS RESULT FROM DUAL;

RESULT
—————
12-DEC-04