Re: Intersolv 3.11 and Informix datetime

This is can depends if you are using win95 or NT, and which ODBC driver you are using. We had a similar problem on win95 pc's but not on NT. First we tried changeing the regional settings, but ended up using Informix's CLI ODBC driver, as our answer. Edward Villalovoz wrote: > I have an odbc connection from Access97 to Informix 7.x on solaris. When I > try to view the data through this odbc connection one of my fields that I > defined as "half_hour datetime hour to minute", I get the date and time > in the field, "1998/08/20 14:00". I only load the hour and minute into the > field, like "14:00". I should be only returning just the hour and minute, > like "14:00". When I view the data in informix i get the right format, but > when i use the odbc connection i get the wrong format. Any ideas? Thanks > in advance. -- Hans Siebrand, jhs@tusc.com.au Laboratory Systems Group, TUSC Computer Systems Pty. Ltd. Phone +61 03 9840 4431 Fax +61 03 9840 2277