Re: NLS_DATE_FORMAT and RR : Doesn't work !

Are you working in a client-server environment, e.g. NT ??

If so, you'll need to set the RR format in the registry also..your client NLS_DATE_FORMAT might still be YY

cheers

Glenn BAron

Emmanuel Guyot <Emmanuel.Guyot._at_wanadoo.fr> wrote in article <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 - 11:24:55 CDT