Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --