Re: Year 2000

}From: lesleys.2@finance.vh.bbc.co.uk (Lesley Simpson-IST) }To: johnl@informix.com (johnl), lester@access.digex.net (Lester Knutsen) }Date: Fri, 18 Jul 1997 10:11:28 +0100 }Subject: Re: Year 2000 } }Lester Knutsen wrote: }>> Jonathan Leffler asked: }>> Note 2: I've heard a report that the Informix SQL-based products prior }>> to release 4.0 have problems with the year 2000. I've been unable to }>> substantiate that report, but if you are still using them, it would be }>> worth checking rather carefully. If anybody does have access to the }>> old products (eg ISQL 2.00, 2.10 or 2.10.03) and can check whether the }>> old products recognize 2000-02-29 as a valid date with DBDATE="y4md-", }>> I would appreciate the feedback. }> }>I tried this on an old NCR Tower using INFORMIX-SQL Version 2.10.00A. }>It accepts 02/29/2000 as a valid date. }> }>Here is the script I used and some output: }> }>create database datechk; }>create table datechk }> ( recno serial, }> recdate date ); }>insert into datechk values ( 0, "01/01/2000" ); }>insert into datechk values ( 0, "02/29/2000" ); }> }>$ isql datechk - }> select * from datechk; }> recno recdate }> }> 1 01/01/2000 }> 2 02/29/2000 }> }>Regards - Lester } }We did a similar check on our machines (SE 2.10.03K; I4GL 1.10.03K1) a few }weeks back, which correctly accepted and displayed 29/2/2000. This is with }DBDATE='DMY4'. } }John, you asked about a DBDATE of 'Y4MD-'. Would a different DBDATE format }have a different effect on the test? No; the only significance is that I specified the format for the DATE literal I quoted (ISO 8601 standard, actually). You're British like me, so you think in terms of "DMY4/"; I'm in America where they contort things to "MDY4/"; by using ISO 8601 "Y4MD-" format, I either offend nobody or everybody, without being ambiguous either. }Steve Fabac's post of 8/7/97 said that he had a problem when he changed the }m/c date to 29/2/2000 and tried to insert ... values (TODAY). We were }intending to do this test as well, but the decision came through to upgrade }anyway, so we decided that it was a moot point for us. BTW , has anyone done }this test on a later version of Informix? } }Lesley It sounds as if the problem may the machine itself... Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>