Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Question on NLS_DATE_FORMAT
You need to set the registry variable NLS_DATE_FORMAT
(under HKLM\software\oracle)
Hth,
Sybrand Bakker, Oracle DBA
Sean <dolans_at_my-deja.com> wrote in message
news:8cie4c$3o8$1_at_nnrp1.deja.com...
> Oracle 8i. When I do a select to_char(sysdate) from dual, I get '06-
> APR-00' I would like the year to be 2000.
>
> I can do an alter session, set nls_date_format = 'DD-MON-YYYY' and ok.
> But I want this to be consistent for every session, stored proc,
> package, etc.
>
> I have gone into my init.ora and set the nls_date_format and restarted
> the instance. I can even use svrmgrl and do a show parameters NLS and
> see that the format is correct.
>
> Why would the date still be returning in 00 format vs 2000?
>
> Thanks,
> Sean
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Apr 06 2000 - 11:57:15 CDT