Re: Y2K QUESTION automatic conversion

From: Barry Jones <jonesb_at_logica.com>
Date: 6 May 1998 15:54:18 GMT
Message-ID: <01bfb773$6bf084b0$fc11ea9e@ukp01758>

Having just tried it by changing the system date on an Oracle7 server to 6-May-2000, the answer is yes.

Barry Jones
Logica UK Ltd.

Tommy Wareing <p0070621_at_brookes.ac.uk> wrote in article <355083e7.104793865_at_news.brookes.ac.uk>...
> What Doug means is
>
> If one converts a string to a date using the YY format mask, then the
> database defaults the century. As we know, this currently defaults to
> 19. But where does this come from? Is it built into the database
> somewhere, or is it taken from the current system date?
>
> This will make a difference come the year 2000:
> '5-MAY-98' currently (today being the 6th May, 1998) means 05/05/1998.
> But what will it mean on the 1st January, 2000? Will it still mean
> 05/05/1998, or will it suddenly mean 05/05/2098?
>
> Unfortunately, I don't know the answer
>

remainder removed.. Received on Wed May 06 1998 - 10:54:18 CDT