ADD_MONTHS is one of the vital Date/Time functions of Oracle. It is used to get a date with a specified number of months added. The ADD_MONTHS function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
ADD_MONTHS ( date, number_months )
date: It is used to specify the starting date.
number_months: It is used to specify the number of months to add.
ADD_MONTHS ( ‘26-JUN-19’, 2)
The result is the date two months from the starting date.
ADD_MONTHS ( ‘26-JUN-19’, -2)
The result is the date two months before the starting date.