Huh thanks,
for my year and half experiences (still during college studies) is
this knowledge far beyond my possibilities (yes, I am still far of "SQL
Fundamentals" - I learn what I need to do in job)
but still thanks for new thing to learn (that's why I try to answer
on these questions - I always learn something new...)
hoppo
On 29. 10. 2010 9:02, serik.sharipov wrote:
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
This troubles can be fixed by:
1. specify NLS parameters in TO_CHAR ;)
for example: to_char(sysdate, 'fmDay ddspth Month yyyy',
'NLS_DATE_LANGUAGE=ENGLISH')
2. non-format-mask strings outputed by quotted strings
for example: to_char(sysdate, 'fmDay "the" ddspth "of" Month yyyy',
'NLS_DATE_LANGUAGE=ENGLISH')
Oracle (9i, 10g) SQL Fundamentals, Chapter 3: Single Row Functions.
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
