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