Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>