Re: NLS_DATE_FORMAT for Y2K

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.
Received on Wed Jul 07 1999 - 09:46:11 CDT