Using TO_DATE Within PL/SQL : TO_DATE « Date Timezone « Oracle PL / SQL






Using TO_DATE Within PL/SQL

   
SQL>
SQL> DECLARE
  2       v_Convert_Date DATE;
  3  BEGIN
  4       v_Convert_Date := TO_DATE('031092','MMDDYY');
  5       DBMS_OUTPUT.PUT_LINE('The converted date is: ' || v_Convert_Date);
  6  END;
  7  /
The converted date is: 10-MAR-2092 00:00:00

PL/SQL procedure successfully completed.

SQL>
SQL> --

   
    
  








Related examples in the same category

1.TO_CHAR(ADD_MON(TO_DATE('29-FEB-2000','DD-MON-YYYY'),1),'DD-MON-YYYY')
2.Use to_date in insert statement
3.to_date() and insert statement
4.Combine to_char, add_months and to_date function