Same way any function there to convert numbers (Currency) into words
S. Thangasamy
MIS Manager
*Tel..........: +966 1 2315577 Ext 209
*Fax...........: +966 1 2300022
*Cell.........: +966 503448347
*E-Mail......: [Email address protected]
"Web Site...: www.safari.com.sa
-----Original Message-----
From: Adam Christie-Grant
[mailto:oracledba-ezmlmshield-x2196204.[Email address protected]
Sent: Tuesday, January 31, 2006 3:26 PM
To: LazyDBA Discussion
Subject: RE: Date to Words
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
--------
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
============
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the addressess(s) named herein. If you are not the intended recipient or addressee, you should not use, disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of "Safari Co. Ltd." and or its subsidiaries.
WARNING: The out bound mails are scanned for presence of any viruses but check this email and any attachments for the presence of viruses. The company accpts no liability for any damage caused by any virus transmitted by this email.
MIS Department
Safari Co. Ltd.
Oracle LazyDBA home page