Re: NLS-Date RR

RR, in my humble opinion, is a kludge...

It is a sliding window type of format that looks at the year to determine the century...51 or greater = 2000 ( I think, it may be lower or higher but that's the general idea)...

I much prefer to use YYYY in all date formats to avoid the problem now and in the future...( Y2K,Y10K, etc )

Also be aware the settings on the client PC will override any on the database itself, and, if any NLS_ parameters are set on the client, ALL unset NLS_ parameters will be set to the Oracle default ( usually DD-MON-YY - not Y2K compliant )

Doug Cowles <dcowles_at_bigfoot.com> wrote:

>Some documentation suggests that "RR" has something to do with the year
>relative to the current year. Can anyone shed some more light on how
>"RR" works? Someone
>else told me it was important for Y2K. Is the effect of NLS-Date
>essentially the
>default format of the system date if none is specified? A couple
>examples of RR would
>be of help...
>
>
>- Dc.
Received on Thu Jul 15 1999 - 11:07:46 CDT