thanks guys On Fri, Oct 29, 2010 at 12:39 PM, Andrej Hopko <ado.ho...@gmail.com> wrote:
> 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 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 > -- 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
