Re: NLS_DATE_FORMAT and RR : Doesn't work !

Hi Emmanuel,
You probably ran this statement from a client. Clients should have their own nls_language and nls_date_format settings, either by setting environment variables (Unix) or registry values (Windows). If these settings do not exist, the defaults will be used. In your to_date clause you are not using the nls_date_format from the server, you are using the (default) nls_date_format from the client. As this is dd-mon-yy, the date returned is 01-dec-1901. Don't ask me why they have implemented it in this way, I don't know. You should be able to find more details on technet.oracle.com or metalink.

Hth,

Sybrand Bakker, Oracle DBA

Emmanuel Guyot wrote in message <7jav3p$qnf$1_at_wanadoo.fr>...
>I've set NLS_DATE_FORMAT to dd-mon-rr instead of dd-mon-yy in my
initxxx.ora
>in order to deal with Y2K problems. I've shutdowned and restarted the base
>(7.3.3) but it doesn't seem to works as I intented it to :
>
>select to_char(to_date('01-dec-01'),'dd/mm/yyyy') from dual;
>
>give the following output :
>
>01/12/1901
>
>Why ? Is the NLS_DATE_FORMAT only for output ?
>
>Thanks for your help.
>
>E.G.
>
>-----------------------------------------------------------------------
>--------------------->>>> Emmanuel Guyot <<<<--------------------------
>8 Rue des Montées | Phone : [33] (0)2 38 56 42 72
>45100 Orléans | Email : emmguyot_at_altavista.net
>France | ICQ : 6945538
>-----------------------------------------------------------------------
>Home Page : http://perso.wanadoo.fr/emmanuel.guyot/belote
>-----------------------------------------------------------------------
>
>
Received on Sat Jun 05 1999 - 09:04:29 CDT