Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Date format

Date format

From: auxitec e2ia <auxitec.e2ia_at_wanadoo.fr>
Date: Thu, 5 Oct 2000 17:05:38 +0200
Message-ID: <8ri6p0$41a$1@wanadoo.fr>

I got a problem with oracle 7.2 and NLS_DATE_FORMAT. In the table my dates is like : 01-JAN-99 but if i use this SQL command :

select to_char(dates,'DD-MM-YYYY') from test;

result is : 01-JAN-2099 but I want : 01-JAN-1999 and I can't give the year with 4 digits with AutoLisp/AutoCAD.

If I put this environment variable in Windows NT4 :

    NLS_DATE_FORMAT = DD-MON-RR
it will working very well,

but i'd like to set this variable in INITCLT.ORA and if I try this :

    NLS_DATE_FORMAT = 'DD-MON-RR'
Nothing append.

Perhaps the syntax is not good.

Thanks for any help,

--
AUXITEC TECHNOLOGIES
ECOPOLIS SUD
36 AV JOSE NOBRE
13500 MARTIGUES
EMAIL- flavien.apoux_at_auxitec.fr
Web: www.auxitec.fr
Received on Thu Oct 05 2000 - 10:05:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US