Re: ODBC Trouble with INTERVAL

Posted in 1998

Don Simpson — Fri, 13 Feb 1998 16:42:57 -0800 — source: Informix-list mailing list archive (1991-1998)

Robert Medearis wrote: > > Can anyone turn on the lights? > > I have a field defined in an Informix table as INTERVAL day(3) to > fraction(4). I am using the Infromix supported ODBC driver, INTERSOLV > 3.01 32-BIT INFORMIX, from within Crystal Reports to produce a report on > the interval fields. The result of the Interval value is displayed as > "INTERVAL'000 00:0" instead of "000 00:00:00.0000" which is what was > produced using my prior ODBC driver. A least it knows that I am looking > for a 17 chars but why am I getting the string "INTERVAL'" return? You need to use Informix CLI. The Intersolv driver can't do intervals. Don.