Re: Year 2000 with online 5.01

GreggD09 wrote: > > "We have a large application running on the Informix V5.01 database. > Currently, the year 2000 rolls over to 1900 causing errors in our > calculations. Are there any easy fixes to this problem such as a > patch or an easily upgradable new version? With the patch or new > version, how difficult of a change could we expect? We have over > 150 programs running Informix 4GL pcode." > > Gregg Knight > Systems Analyst / Programmer > Informix / UNIX Please provide some more details. As far as I know, if you used the DATE data-type you shouldn't get such problems. Informix engines record the DATE information as an integer value corresponding to the number of days the stored date value is from December 31, 1899. Since the INTEGER data type can go up to 2.147 billion (correct me if I'm wrong) then the system should be able to store dates well into the 25th century. If, on the other hand, the programs implemented dates using the CHAR data type (in COBOL style) then you have some work to do. I'm not sure if you can convert directly from CHAR dates to INTEGER dates. Perhaps someone else knows? Perhaps you could clarify what you mean by "... the year 2000 rolls over to 1900 ..." Best regards, Nigel -- +--------------------------------------------------------------------+ | Name : Edmund Nigel Gall Address: 9A Stanmore Avenue | | Title : Account Executive Port of Spain | | Company : Stratis Caribbean Ltd. Trinidad & Tobago, W.I. | | | | Contact Information: | | Office Personal | | Voice : (809) 623 6530/1 (809) 662 6611 | | Fax : (809) 623 8370 (809) 662 6611 | | Email : ngall@stratis-caribbean.com nigelg@trinidad.net | +----------------- http://www.stratis-caribbean.com -----------------+