ADD_MONTHS

Adds to the date value specified by the date_expression, the given number of months specified by integer_expression, and returns the resultant date value.

Syntax

ADD_MONTHS ( date_expression , integer_expression )

Notes

The first argument must be of DATE type.

The second argument to the function must be of NUMERIC type.

The result is of type DATE.

If any of the arguments evaluates to NULL, the result is NULL.

Example

This example illustrates the ADD_MONTHS function:

SELECT *
FROM customer
WHERE ADD_MONTHS (start_date, 6) > SYSDATE ;

Compatibility

Progress extension