Re: Displaying Thai Buddha NLS_Calendar with American NLS_Date_Language

Thanks for the reply,

Do you know if there is a bug with the NLS_DATE_LANGUAGE not working properly with Asian languages in Oracle 8i?

In the mean time, I will write several date functions to return several formats of the varchar date with an English month or abbreiation as a work around.

FYI, the "Day" or "DY" format abbreviations work and return Tuesday, or Tue, respectively when setting NLS_DATE_LANGUAGE = "AMERICAN"... it is just the months.

"mcstock" <mcstockx_at_xenquery.com> wrote in message news:<tcmdnWQPFN6u0z-iRVn-jg_at_comcast.com>...
> you may need to write a custom function as a work-around -- have your
> function concatenate the values returned from to_char for the Thai Buddha
> year) to the English month -- likely you'll have to hard-code the English
> month names.
>
> -- mcs
>
> "DannyM" <dannyjm_at_aol.com> wrote in message
> news:e7ff45b0.0310310118.2b760c56_at_posting.google.com...
> > Hi
> >
> > I am have difficulties displaying dates in the NLS_DATE_LANGUAGE I
> > specify.
> >
> > When
> >
> > NLS_CALENDAR = Thai Buddha
> > NLS_DATE_FORMAT = DD-Month-YYYY
> > NLS_DATE_LANGUAGE = AMERICAN
> >
> >
> > select sysdate from dual;
> >
> > SYSDATE
> > ----------------------
> > 31-_at_@$@#-2546
> >
> > (where the _at_@$@# is the month written properly in Thai (I just cannot
> > display in this message)
> >
> > However, the result should be
> >
> > SYSDATE
> > -------------------
> > 31-October-2546
> >
> > (this is the correct date in Thailand and equivalent to 31-Oct-2003 in
> > the Gregorian Calendar)
> >
> > Also, the statement
> >
> > select to_char(sysdate, 'DD-Mon-YYYY', 'nls_date_language = american')
> > from dual;
> >
> >
> > TO_CHAR(SYSDATE,'DD-'
> > ----------------------
> > 31-_at_@$@#-2546
> >
> >
> > So, it seems as if the NLS_DATE_LANGUAGE has no effect on the Thai
> > Buddha Calendar. If I switch the calendar back to Gregorian I can use
> > the NLS_DATE_LANGUAGE to switch between English, French, etc display
> > of weekdays and months.
> >
> > I see a few posts on Oracle's web site about having difficulties
> > displaying "Asian Calendars" in western languages. No soultions were
> > give..
> >
> > Has anyone experienced this or have a work around.
> >
> > Thanks,
> >
> > Dan
Received on Sun Nov 02 2003 - 13:25:29 CET