Depends how you want it to appear :

select to_char(sysdate,'DAY DD MONTH MON YYYY YY RR YEAR') from dual;

TO_CHAR(SYSDATE,'DAYDDMONTHMONYYYYYYRRYEAR')
----------------------------------------------------------------------------
----
TUESDAY 31 JANUARY JAN 2006 06 06 TWO THOUSAND SIX

Hope that helps :o)

Adam

-----Original Message-----
From: nsk [mailto:oracledba-ezmlmshield-x62190355.[Email address protected]
Sent: 31 January 2006 11:51
To: LazyDBA Discussion
Subject: Date to Words

Hi,

Can any one help me to display the date field value in words in a select
query

----- nsk


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page