Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Combine to_char, add_months and to_date function

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