Oracle ADD_MONTHS function.

Preamble

The Oracle/PLSQL ADD_MONTHS function returns a date plus n months.

Oracle/PLSQL syntax of ADD_MONTHS function

ADD_MONTHS( date1_id, n_id )

Parameters and function arguments

• date1_id – start date.
• n_id – number of months that will be added to date1.

Function ADD_MONTHS returns date.

The ADD_MONTHS function can be used in the following Oracle/PLSQL versions

Let’s consider some examples of the ADD_MONTHS function and learn how to use ADD_MONTHS function in Oracle.

SELECT ADD_MONTHS('01-AUG-14', 3) FROM DUAL;

--Result: 01.11.2014

SELECT ADD_MONTHS('01-AUG-14', -3) FROM DUAL;

--Result: 01.05.2014

SELECT ADD_MONTHS('21-AUG-14', -3) FROM DUAL;

--Result: 21.05.2014

SELECT ADD_MONTHS('31-January-14', 1) FROM DUAL;

--Result: 28.02.2014

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​