ADD_MONTHS
The ADD_MONTHS function returns a date with a specified number of months added. The function returns a date value.
Syntax
ADD_MONTHS( datetime_value_expression, number_months)
Example
ADD_MONTHS(DATE '2001-08-01', 3)
Result: DATE '2001-11-01'