Re: NLS_DATE_LANGUAGE...

I found my answer,
thanks.
http://groups.google.ca/groups?q=nls_date_language&hl=en&lr=&ie=UTF-8&oe=UTF -8&selm=366AA17E.97AE29E4%40ncom.nnov.su&rnum=1

"Nicolas Payre" <nicpayre_at_sympatico.ca> wrote in message news:BpIqa.5949$2g5.912031_at_news20.bellglobal.com...
> Hello,
> My system (w2k) is all english except for the "Input Locales" (keyboard)
> wich is French Canadian, why the following date is in french??
>
> SQL> select to_char(to_date('02-02-02'),'dd-mon-yy') from dual;
>
> TO_CHAR(T
> ---------
> 02-fév-02
>
> As you can see the month is written fév instead of feb as would prefeer...
>
> The thing is resolve if i use the ALTER SESSION SET
> NLS_DATE_LANGUAGE='AMERICAN', but i can't figure who to change it for a
> sqlloader session, is the only way is to set it via environement variable?
 I
> would like to change it permanetly, or at lest for on SCHEMA in
 particular,
> is it possible?
>
> Here my NLSs parameters:
>
> nls_calendar string
> nls_comp string
> nls_currency string
> nls_date_format string
> nls_date_language string
> nls_dual_currency string
> nls_iso_currency string
> nls_language string AMERICAN
> nls_length_semantics string BYTE
> nls_nchar_conv_excp string FALSE
> nls_numeric_characters string
> nls_sort string
> nls_territory string AMERICA
> nls_time_format string
> nls_timestamp_format string
> nls_timestamp_tz_format string
> nls_time_tz_format string
>
> Thank,
>
>
Received on Sun Apr 27 2003 - 22:47:26 CEST