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>

Related examples in the same category

1.	TO_CHAR(Date, 'Mon')
2.	TO_CHAR(Date, 'Month')
3.	TO_CHAR(Date, 'YYYY')
4.	TO_CHAR(Date, 'MM')
5.	TO_CHAR(Date, 'Year')
6.	TO_CHAR(Date, 'Day')
7.	TO_CHAR(Date, 'DY')
8.	TO_CHAR(Date, 'Q')
9.	TO_CHAR(Date,'DAY MONTH DD, YYYY')
10.	TO_CHAR(Date,'fmDay Month fmDD, YYYY'): Embedded spaces can be removed by placing the 'fm' prefix
11.	TO_CHAR(Start_Date, 'DD, MM, Mon, Month, YYYY, Year, Day, DY, Q')
12.	Suffix 'sp': spell out a numeric value
13.	'th' suffix: add an ordinal ending to a numeric format element
14.	The TO_DATE function in where clause
15.	Format current system date: 'dd Mon, yyyy hh24:mi:ss'

Converting DATE to spelled-out character format : TO_Char Date « Data Type « Oracle PL / SQL

Related examples in the same category