Very Computer

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

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.

Quote:> 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