Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Combine ADD_MONTHS() with TO_CHAR() and TO_DATE

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