Re: RR Date Boundary

From: Paul Drake <paled_at_home.com>
Date: Sat, 21 Jul 2001 21:31:52 GMT
Message-ID: <3B4724CD.89271B35@home.com>

Kevin Zarzecki wrote:

> 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

Kevin,

why not use a 4 digit year? (e.g. 'RRRRMMDD' or 'DD-MON-RRRR') a column having a data type of DATE is stored the same way - regardless of formatting.

hth.

Paul Received on Sat Jul 21 2001 - 16:31:52 CDT