SQL> SQL> -- Using TO_DATE within PL/SQL. SQL> DECLARE 2 v_Convert_Date DATE; 3 BEGIN 4 v_Convert_Date := TO_DATE('061167','MMDDYY'); 5 DBMS_OUTPUT.PUT_LINE('The converted date is: ' || v_Convert_Date); 6 END; 7 / The converted date is: 11-JUN-67 PL/SQL procedure successfully completed. SQL>