Re: Year 2000 and clarification of Informix official statement

Ian Clark wrote: > will we be ok accepting 2 digit > years? All our date columns are defined as DATE columns and I am > presuming that Informix looks up the century from the operating system > and correctly posts the century to any DATE columns. Am I right? Sorry, you're wrong. When DBCENTURY is not supported by your version of Informix products, any two-digit-year dates are always assumed to be in the 20th century by Informix. This is the behavior that is specifically addressed by the DBCENTURY feature. Time to upgrade if you have to insist on 2-digit years. Regards, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+