Re: Year 2000 problem
Date: 1996/04/23
Message-ID: <michel.lalonde.74.00093C02_at_sit.ulaval.ca>#1/1
In article <4lgrqu$d39_at_tekadm1.cse.tek.com> johnhi_at_biker.pen.tek.com (John Higley) writes:
>From: johnhi_at_biker.pen.tek.com (John Higley)
>Subject: Re: Year 2000 problem
>Date: 22 Apr 1996 20:57:02 GMT
>Hello,
> I had a thought - what if the format "yyyy" behaved in a "good" way? For
> instance: If I set up an input format of "dd-mon-yyyy" and the user
> accidently forgot to say 1996 - instead he just said 96, wouldn't it be
> nice of Oracle to use 19 as the century?
> As it is, they change 96 to 0096 and they do not consider it an error!
> I can see a lot of bad dates being entered because of this.
We add constraints to check that dates are between 1900 and 2099.
Michel Lalonde. Received on Tue Apr 23 1996 - 00:00:00 CEST