Y@K ?
Posted in 1999
Topics: General Discussion
This should be an easy one for one of you Informix techies. I have recently been given responsibility for a small database that uses an Informix-SE engine (ver 4.10.UC2) and runs on an SCO OS5 box and am attempting to test it for Y2K compliance. I have discovered that dates inserted or referenced with two digit centuries are interpreted by the engine as 1900 even if the system date is 2000. Is there a setting or environment variable that is causing the system century to not be the default? Any ideas on this will be greatly appreciated. Sent via Deja.com http://www.deja.com/ Before you buy.
Yes, it is easy . . . Go to http://www.informix.com/informix/products/year2000/prodready.htm . All products are listed for Y2K support and compliance. wtmckown@my-deja.com wrote: > > This should be an easy one for one of you Informix techies. I have > recently been given responsibility for a small database that uses an > Informix-SE engine (ver 4.10.UC2) and runs on an SCO OS5 box and am > attempting to test it for Y2K compliance. I have discovered that dates > inserted or referenced with two digit centuries are interpreted by the > engine as 1900 even if the system date is 2000. Is there a setting or > environment variable that is causing the system century to not be the > default? Any ideas on this will be greatly appreciated. > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */