Hi,
just look at this one:
SELECT TO_CHAR(TO_DATE('01.02.2006','DD.MM.YYYY'),'Day ddspth Month
YYYY') formated
FROM DUAL
/FORMATED
------------------------------
Wednesday first February 2006
/
problem is that DAY and MONTH are affected by NLS settings (native
language set to session or default to DBMS) but DDSPTH always shows
"first" in English - so problem in other uses than in English
Second problem - formatter does not insert "the" and "of" words so you
need to split it to more TO_CHAR functions and join them to have result
you want
note that case of formater string defines the case of resulting text
(that I found just now =) )
regards
hoppo
On 29. 10. 2010 7:23, Yuvaraj Sundaresan wrote:
Hi,
This is yuvaraj.
How to print the date format as shown below :
Wednesday the first of February 2006
Thanks in advance
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
