Using TO_DATE Within PL/SQL: TO_DATE('031092','MMDDYY') : TO_DATE « PL SQL Programming « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Programming
  3. TO_DATE
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-92

PL/SQL procedure successfully completed.








24.7.TO_DATE
24.7.1.Use TO_DATE function in PL/SQL
24.7.2.TO_DATE('1/1/02','mm/dd/yy')
24.7.3.TO_DATE('1-1-1998','mm-dd-yyyy')
24.7.4.TO_DATE('Jan 1, 2000','mon dd, yyyy')
24.7.5.Using TO_DATE Within PL/SQL: TO_DATE('031092','MMDDYY')