Re: implications of RR change in init.ora

From: Steve Halko <steveh_at_redshift.com>
Date: Thu, 13 Jan 2000 19:45:13 -0800
Message-ID: <s7t71iqooj8123@corp.supernews.com>

Since RR will translate all dates into the range 1950-2049, then it should work fine if all your date data is within that range. In our situation, that is NOT the case, so we changed NLS_DATE_FORMAT to 'MM-DD-YYYY'.

The only way to avoid Y2K problems is to use only 4-digit years - then the NLS_DATE_FORMAT you use will not matter. In our shop, it is considered poor programming practice to rely on NLS_DATE_FORMAT - we always provide an explicit date format mask in our code when we can.

"ParK" <rk_at_myremarq.com> wrote in message news:387DDE23.5D5788EF_at_myremarq.com...
> Hi!
>
> I know Y2K has come and gone, but does any one has any advice/experience
> regarding changing the setting of NLS_DATE_FORMAT
> to 'DD/MM/RR' in the init.ora file? What needs to be considered for
> that change, how would that effect any runtime environment, etc.
>
> The OS being used is Digital Unix 4.0.
>
> Thanks
> ParK
Received on Thu Jan 13 2000 - 21:45:13 CST