TO_CHAR(ADD_MON(TO_DATE('29-FEB-2000','DD-MON-YYYY'),1),'DD-MON-YYYY') : TO_DATE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_DATE

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> --








Related examples in the same category

1.Use to_date in insert statement
2.Using TO_DATE Within PL/SQL
3.to_date() and insert statement
4.Combine to_char, add_months and to_date function