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'