Re: Year 2000 Impact on Informix

Posted in 1997

Dmitry Kazarov — Fri, 25 Apr 1997 11:29:33 +0400 — source: Informix-list mailing list archive (1991-1998)

KENDRICKS.CHERYL@heb.com wrote: > How is your code populating this database? In Informix 5.X and 7.1 if you > enter two digits for a year and the column is data type date, well "Informix > products assume that the year is in the twentieth century and assign the > numbers 1 and 9 (19) as the first two digits of the year". From Informix 7.22 "Guide to GLS Functionality", p 2-29: "...formatting directives ... assume the current century for a 2-digit year. However, you can set the DBCENTURY environment variable to change this assumption." Informix ODS 7.12 does not support it. > > Did some smart programmer or administrator change the environment variable > DBTIME or DBDATE to NOT use the century portion of date (duh!!! shoot them > you Y2K programmers). Change it NOW. -- Dmitry Yu. Kazarov Server Ltd, Moscow Phone: (+7 095) 434-7647 Fax: (+7 095) 434-8447 mailto: dima@server.ru