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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question on NLS_DATE_FORMAT

Re: Question on NLS_DATE_FORMAT

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 6 Apr 2000 18:57:15 +0200
Message-ID: <955043353.6182.1.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

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