Hello,
My Application Primary Language is "English (United States) [en-us]"
My Application Language Derived From is "Browser (use browser language preference)"
My Internet Explorer 6.0 Language Preference is "English (Canada) [en-ca]"
Should'nt this set my default date format to the Canadian format of YYYY-MM-DD? I am using Apex 2.0.
When I do a debug, I get the following information:
0.00: alter session set nls_language="ENGLISH"
0.00: alter session set nls_territory="CANADA"
0.00: NLS: CSV charset=WE8MSWIN1252
0.00: ...Setting NLS Decimal separator=","
0.00: ...Setting NLS Group separator=" "
0.00: ...Setting NLS date format="RR-MM-DD"
0.00: NLS: Language=en-ca
Refer to "HTMLDB - HOWTO Work with Dates" on Page 2 of the following Link, as the globalization experts in Oracle was to look into this.
282437
See also
1036738
Paul.