Re: NLS_DATE_FORMAT for Y2K

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_at_newsr2.maine.rr.com>,   "Chris Drew" <cdrew_at_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_at_maine.rr.com
>
> coakleyj_at_hotmail.com wrote in message <7lqt8a$p5k$1_at_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_at_bgtnsc01.worldnet.att.net>,
> > "Frank Siegel" <NorthernSnow_at_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. Received on Wed Jul 07 1999 - 13:29:47 CDT