Re: does informix RDBMS has year 2000 problem or not?

cjhwang@ms14.hinet.net wrote: > > Anyone knows, please advice, thank you!!! No. The Informix database engine has always stored century safe DATE and more recently DATETIME values. There is however, a problem with earlier versions of the Informix enfgines and front-end development tools like ESQL, 4GL, and NewEra when DATE columns are formatted for output and in how 2 digit years are interpreted when 2 digit years are inserted into a DATE column (2 digit years are illegal in DATETIME). Early engines always assumed 19xx for 2 digit years. This is controlled in later versions by an environment variable. Note that if 4 digit years were entered into even the earliest Informix servers they were correctly stored. Art S. Kagel