Re: Year 2000 problem

John Higley <johnhi_at_biker.pen.tek.com> writes:  

> 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.
>
> On the other hand, if Oracle would recognize that only two digits were
> given, they could default the first 2. Likewise, if the format "rrrr"
> existed, they could do the appropriate thing. This would allow users to
> enter 2 digit years, or if needed, to enter the 4 digit year.
 

The format RRRR does exist, at least in Oracle Forms. It is definitely the best solution for application programmers.  

• Rick --

(Rick Rutt is a system architect living and working in Midland, Michigan.) Received on Tue Apr 23 1996 - 00:00:00 CEST