Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

Converting DATE to a Spelled-Out Character Format

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.