Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

TO_CHAR(ADD_MON(TO_DATE(29-FEB-2000,DD-MON-YYYY),1),DD-MON-YYYY)

SQL> SQL> SELECT TO_CHAR(ADD_MON(TO_DATE('29-FEB-2000','DD-MON-YYYY'),1),'DD-MON-YYYY')   2  FROM dual; TO_CHAR(ADD ----------- 29-MAR-2000 1 row selected. SQL> SQL> SQL> --