Re: RR Date Boundary

From: David Richardson <drichardson_all4one_at_yahoo.com>
Date: Sat, 21 Jul 2001 21:27:36 GMT
Message-ID: <3B43670A.29800AEA@yahoo.com>

And this is exactly how we will start to see the effects of Y2K. Most won't even realize that theyhave introduced a problem until it is too late.

dratster

Sybrand Bakker wrote:

> "Kevin Zarzecki" <kevin_at_regus-cs.co.uk> wrote in message
> news:994259169.3766.0.nnrp-14.c1ed11ad_at_news.demon.co.uk...
> >
> > Hi,
> >
> > Can anyone tell me if it is possible to change the default date boundary
> > Oracle sets for the RR format. (This is the boundary that says any date
> > before 1950 should begin 20.)
> >
> > We are using 8.1.6. and trying to enter birthdates prior to 1950 e.g.
1948,
> > but Oracle is interpreting this as 2048.
> >
> > We have to use the RR/RRRR format to store and retrieve dates, but it
would
> > be useful if we could change the boundary by 20/30 years.
> >
> >
> >
> > Thanks for any advice.
> >
> >
> > Cheers,
> >
> >
> > Kevin
> >
> >
>
> This is not possible.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Sat Jul 21 2001 - 16:27:36 CDT