Re: Year 2000

From: T Ojala <tojala_at_cc.jyu.fi>
Date: 1997/04/21
Message-ID: <335b8770.10279397@news.sci.fi>#1/1

Alex Heney <heneya_at_entcf3.agw.co.bt.uk> wrote:

>Michael Pasternak wrote:
>>
>> Oracle appears to always default to 1900 if you give it a two digit
>> year.
>>
>> Mike
>>
>
>Not if you give it the format 'RR' rather than 'YY' (e.g. 'DD-MON-RR' if
>01-JAN-02 was entered, would be stored as 2002.
>
>RR takes any year > 49 to be 19xx, and year < 50 to be 20xx.
>
>--

Actually, Oracle seems to default to the current century when using the format 'DD-MON-YY'. So '21-apr-97' would give 21-apr-1997 when given today, but 21-apr-2097 when given five years from now. I tested this few months ago, BUT PLEASE CORRECT ME IF I'M WRONG.

Tane Received on Mon Apr 21 1997 - 00:00:00 CDT