NLS_DATE_FORMAT and RR : Doesn't work !

From: Emmanuel Guyot <Emmanuel.Guyot._at_wanadoo.fr>
Date: Sat, 5 Jun 1999 12:47:49 +0200
Message-ID: <7jav3p$qnf$1@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 - 05:47:49 CDT