Displaying Thai Buddha NLS_Calendar with American NLS_Date_Language

[DannyM]

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-@@$@#-2546

(where the @@$@# 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-@@$@#-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

[mcstock]

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@aol.com> wrote in message
news:e7ff45b0.0310310118.2b760c56@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-@@$@#-2546 (where the @@$@# 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-@@$@#-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

[DannyM]

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@xenquery.com> wrote in message news:<tcmdnWQPFN6u0z-iRVn-jg@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@aol.com> wrote in message news:e7ff45b0.0310310118.2b760c56@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-@@$@#-2546 (where the @@$@# 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-@@$@#-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