Re: Year 2000

Jonathan, > 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 ############################################################################# # Lester Knutsen lester@advancedatatools.com # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.advancedatatools.com # # Washington Area Informix User Group: http://www.iiug.org/~waiug/ # #############################################################################