ADD_MONTHS function in Oracle

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.

Syntax:

ADD_MONTHS ( date, number_months )	

Parameters: date: It is used to specify the starting date. number_months: It is used to specify the number of months to add.

Example 1:

ADD_MONTHS (26-JUN-19’, 2)

Output:

‘26-AUG-19’

Explanation: The result is the date two months from the starting date.

Example 2:

ADD_MONTHS (26-JUN-19’, -2)

Output:

 ‘26-APR-19’

Explanation: The result is the date two months before the starting date.

Please follow and like us:
Content Protection by DMCA.com