Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RR Date Boundary

Re: RR Date Boundary

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:27:16 GMT
Message-ID: <tk6gkb3k45oa24@beta-news.demon.nl>

"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:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US