Re: Year 2000

Nils Myklebust (Nils.Myklebust@idg.no) wrote: : But I do believe ver. 4.x is as year 2000 compliant as anything except : for it not supporting the dbcentury environement variable. That is you : will have to show and key in years with 4 digits. Dates have allways : been represented the same way internally in Informix engines, so there : ought not to be any problem. If "year 2000 compliance" is defined as storing 4-digit years and not getting confused when the millenium hits, then yes, all Informix versions are "year 2000 compliant". The two things to be aware of with the older versions of products is lack of support for DBCENTURY (as mentioned above) and the fact that 2-digit years will be defaulted to 19xx, even after the year 2000. This means that if you say: INSERT INTO orders (order_date) VALUES ("11/11/11");You will get November 11, 1911, no matter what the current year is. June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: home ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.