Re: Y2K

Art S. Kagel wrote: > > Raghava Ponnapalli wrote: > > > > Is Informix (7.13 UC2)Y2K compliant ? Thanks for your help > > The Informix database itself has always been Y2K compliant in that it > always stores year with century. However, in versions before 7.24, > which has the DBCENTURY environment variable to control how to expand > 2 digit date strings on input, any date string inserted into a date > type column which did not contain a century the century was assumed to > be 19. This means that "01/01/01" would be inserted as January 1, > 1901. > > So yes the database is but your apps will have to insert 4digit years > for the data to be interpreted correctly. Versions beginning with 7.24 > support DBCENTURY. Versions beginning with 7.20 actually. :-) Both IDS and SE..... and ESQL and 4GL and SQL and CONNECT and...... ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+