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