Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Date format
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.frReceived on Thu Oct 05 2000 - 10:30:31 CDT
![]() |
![]() |