Xref: alice comp.databases.oracle.server:56392
Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: coakleyj@hotmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: NLS_DATE_FORMAT for Y2K
Date: Wed, 07 Jul 1999 18:29:47 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 98
Message-ID: <7m06aa$kdo$1@nnrp1.deja.com>
References: <7lj536$spa$1@bgtnsc01.worldnet.att.net> <7lqt8a$p5k$1@nnrp1.deja.com> <0JJg3.3746$AZ2.4053@newsr2.maine.rr.com>
X-Article-Creation-Date: Wed Jul 07 18:29:47 1999 GMT
X-Http-User-Agent: Mozilla/2.0 (compatible; MSIE 3.01; Windows 95)
X-Http-Proxy: 1.0 x21.deja.com:80 (Squid/1.1.22) for client 193.131.169.67



On Windows 95, edit the nls_date_format and
nls_lang settings in the registry.

i.e regedit,
navigate to local machine, --> software --> Oracle.

Ensure nls_lang is set - typically "AMERICAN_AMERICA.we8iso8859p1"
for western European.
Then set nls_date_format to "DD-MON-YYYY" or
"DD-MON-RRRR", or "DD-MON-RR"
This doesn't make everything Y2k compliant,
but helps on the way.

Coakleyj

in article <0JJg3.3746$AZ2.4053@newsr2.maine.rr.com>,
  "Chris Drew" <cdrew@maine.rr.com> wrote:
> What 95 parameter do you change or add to make it y2k...??  I know how to
> alter NT, but the same doesn't work for 95.
>
> cdrew@maine.rr.com
>
> coakleyj@hotmail.com wrote in message <7lqt8a$p5k$1@nnrp1.deja.com>...
> >Hi.
> >It's your session parameters that drive the rules,
> >and not the database parameters. Database parameter
> >will only "kick-in" when your local nls_lang is not set.
> >
> >Thus, check your session parameters as follows:
> >
> >select * from nls_session_parameters;
> >
> >Also do a
> >select * from nls_database_parameters;
> >
> >You may find then nls_date_format is DD-MON-YY
> >for your session, even though it's DD-MON-RR
> >for the databse.
> >Change this by:
> >
> >alter session set nls_date_format='DD-MON-RR'
> >or use registry settings (Windos95) or environment
> >variables on Unix.
> >
> >Bye
> >Coakleyj
> >
> >In article <7lj536$spa$1@bgtnsc01.worldnet.att.net>,
> >  "Frank Siegel" <NorthernSnow@worldnet.att.net> wrote:
> >> Thanks much for any help you may provide.
> >> I am running oracle 7.3.x.x and have set the nls_date_format to
> dd-mon-rr.
> >> Here's the proof:
> >>
> >>      > select    substr(name,1,20),       substr(value,1,20)
> >>           from sys.v_$parameter  where name like '%nls_date%'
> >>
> >>         nls_date_format               2 DD-MON-RR
> >>
> >> I have created a 1 row, 1 column table:
> >> > desc test_y2k
> >>     col1   date
> >>
> >> Here is all that is in the table:
> >> > select  col1  from  test_y2k;
> >>    05-JAN-11
> >>
> >> The "RR" is not acting as expected when I perform the following query.  I
> >> thought I would get 2011
> >> and not 1911.
> >>
> >> >select  DECODE(to_char(col1  ,  'YYYY-MON-DD'),
> >>                                      '2011-JAN-05'   ,    '2011',
> >>                                      '1911-JAN-05'   ,    '1911',
> >>                                      'OTHER'   )
> >>     from test_y2k ;
> >>
> >> I get:
> >> 1911
> >>
> >> I get this even if I put RRRR instead of YYYY I get 1911.  What's wrong!
> >> Thanks Again,
> >> Frank S.
> >> New Hampshire
> >>
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.