Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. Converting DATE to spelled-out character format
SQL>
SQL> -- Converting DATE to spelled-out character format.
SQL> SELECT TO_CHAR(SYSDATE,'MONTH DDTH YYYY') "Today" from DUAL;
Today
-------------------
AUGUST    31ST 2006
SQL>