Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Combine ADD_MONTHS() function with To_Date

SQL> SQL> SELECT ADD_MONTHS(TO_DATE('01-JAN-2005 19:15:26',   2    'DD-MON-YYYY HH24:MI:SS'), 2)   3  FROM dual; ADD_MONTH --------- 01-MAR-05 SQL>