RE: Y2K problem on Standard Engine

Posted in 1999

Goldsbrough, David — Wed, 22 Dec 1999 14:14:26 -0000 — source: Informix-list mailing list archive (1991-1998)

Are you using the DBCENTURY Environment Variable? > -----Original Message----- > From: Carlos [SMTP:peisa@peisa.com] > Sent: 22 December 1999 08:53 > To: informix-list@iiug.org > Subject: Y2K problem on Standard Engine > > We've got a problem with dates in SQL. > The next query results in -1204 error (invalid year in date). > > select ..... where date_field = "290200" > > In the other hand these querys work fine : > > select ...... where date_field = "280200" > > select ...... where date_field = "290204" > > Does anyone have any idea? > > Thanks in advance > > >

Related threads

RE: DATES MANAGEMENT ON C-ISAM 5.00
Let me be the first
dbimport error: 1204 - Invalid year in date