Re: Year 2000

From: Alex Heney <heneya_at_entcf3.agw.co.bt.uk>
Date: 1997/04/17
Message-ID: <33563F8B.7AEC@entcf3.agw.co.bt.uk>#1/1

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.

-- 
The above posting represents the personal opinions of the author and
is not to be taken as official (or unofficial) policy or opinions of 
his employer.

Alex Heney, Living in the Global Village.

Received on Thu Apr 17 1997 - 00:00:00 CDT