Re: Date format

Hi,

The NT environment variable controls the client application (i.e. Forms). The initXXX.ora parameter is controlling the server side. So the result of the YY years will be interpreted different depending on how an dwhere you select and display the values.

auxitec e2ia wrote:

> 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

--
Kind regards

Michael Ringbo

(please remove NOSPAM) from the email address when contacting)