Oracle PL/SQL/PL SQL/Date Convert

Converting DATE to spelled-out character format

   <source lang="sql">

SQL> -- Converting DATE to spelled-out character format. SQL> DECLARE

 2        myDate DATE := TO_DATE("06112067BC","MMDDYYYYBC");
 3        myString VARCHAR2(100);
 4  BEGIN
 5        myString := TO_CHAR(myDate,"MMDDSYYYY");
 6        DBMS_OUTPUT.PUT_LINE("The converted date is: " || myString);
 7  END;
 8  /

The converted date is: 0611-2067 PL/SQL procedure successfully completed. SQL>

      </source>
   
  

Using TO_DATE within PL/SQL

   <source lang="sql">

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>

      </source>