Converting DATE to spelled-out character format : Date Convert « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Date Convert

Converting DATE to spelled-out character format


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>








Related examples in the same category

1.Using TO_DATE within PL/SQL