Re: Can't change the nls_date_format!

If you are going to 4 digit format, it is better to use 'YYYY'. This has always worked. In some older 7.xxx releases 'RRRR' did not work properly. i.e it gave 9898 rather than 1998 and bombed.

Van Messner <vmessner_at_netaxis.com> wrote in article <6iqjd7$fs5$1_at_news7.ispnews.com>...
> If you're thinking of changing to 'RR' take a look at 'RRRR'. For some
> installations it offers the best of both worlds.
> Van

snip

>
> Linkage wrote in message <6inevs$e051_at_news.hk.linkage.net>...
> >Hi,
> >
> > Does anyone know how to set up Oracle server to prevent the problem
of
> >yr2k? In my company, we just change the nls_date_format from "DD-MON-YY"
to
> >"DD-MON-RR". Is there any better method?

> >Best Regards,
> >Man Yeung
> >
> >
>
>
>
Received on Mon May 11 1998 - 09:37:34 CDT