Re: Informix 7.2 Y2K Issue

Robert Dont you mean DBCENTURY? Dont know about your FE, but setting DBCENTURY to C will cause the date closest to current date, ie (01/01/1900...today...01/01/2000) to be saved, in this case 01/01/2000. HTH Sujit Robert Trenczer <rtrencze@vbws01.ba.ford.com> on 07/07/99 10:24:38 AM Please respond to rtrencze@vbws01.ba.ford.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Informix 7.2 Y2K Issue I need some help solving a Y2K issue I have with Informix. Here's the situation: I wrote a front-end system in VB that queries, displays, and updates multiple tables in Informix. I am using an ODBC connection. On queries that update date fields in the db, I find that sending a date in the format '01/01/00' is saved in Informix as '01/01/1900'. I verified in ISQL this same problem using the identical update query. My DBA changed the environment variable DBCONFIG to 'F'. In ISQL, the problem disappeared. '01/01/00' was correctly interpretted as '01/01/2000'. But when I used my front-end system, it still came up as 1900. Does anyone have a suggestion other than changing my front-end to accept 4-digit years? Thank you, Bob Trenczer