SQL>
SQL> set serveroutput on
SQL> set echo on
SQL>
SQL> DECLARE
2 v_Convert_Date DATE := TO_DATE('06112067BC','MMDDYYYYBC');
3 v_Hold_Date VARCHAR2(100);
4 BEGIN
5 v_Hold_Date := TO_CHAR(v_Convert_Date,'MMDDSYYYY');
6 DBMS_OUTPUT.PUT_LINE('The converted date is: ' || v_Hold_Date);
7 END;
8 /
The converted date is: 0611-2067
PL/SQL procedure successfully completed.