Date Functions: Add_Months

Description: Add a month or months to a given date.

ADD_MONTHS(<date>, <number OF months_integer>
 
SELECT ADD_MONTHS(SYSDATE, 2) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('27-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('28-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('29-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('30-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('31-JAN-2007'), 1) FROM dual;
 
SELECT ADD_MONTHS(TO_DATE('01-FEB-2007'), 1) FROM dual;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.