ORACLE ADD_MONTHS DATETIME FUNCTION

ORACLE ADD_MONTHS DATETIME FUNCTION

  Oracle Add_months adds number of months to a Date type and returns Date Type.

Syntax:

                   Add_months(Date,[number of months])  returns [new Date object]

Get Next Month:

select add_months(sysdate,1) "next month" from dual;

Get Previous Month:

select add_months(sysdate,-1) "previous month" from dual;

Get Next  Year Same Day:

SQL>select add_months(sysdate,12) "Next Yr Same Day" from dual;

Add 5 yrs to Sysdate.

SQL> select add_months(sysdate,5*12) "After 5 years date is" from dual;

Add  3 quarters to a Date.

SQL> select add_months(sysdate,3*4) "After  3 quarters date is" from dual;

TAGS: get previous month in Oracle, Get Next Month in Oracle, get Next year same day, get n years after. add_months oracle date time.