On Mon, Jan 12, 2004 at 12:55:07AM -0000, Andy Hassall wrote: > Tim Bunce wrote: > > > > Darn it! Where are the various TIMESTAMP and INTERVAL types I was > > expecting to find? Is the ODBC driver manager recent (v3 ODBC specs?) > > The Oracle ODBC driver docs appear to say they don't support INTERVAL. > > (Says this in the helpfile installed when you install the ODBC driver, in > Oracle ODBC Driver Help / For All Users / Oracle ODBC Driver / Features Not > Supported) > > Can't find a mention of TIMESTAMP though. Then again there's not much 9i > information in them - they look very much like the 8i docs, except for one > mention of supporting failover in 9.2.0.4.
Thanks. For now I'm taking the view that if Oracle's ODBC driver doesn't return type info for all types then I don't have to either :-) Patches most welcome (against 1.15) to add in the extra type info. Tim. p.s. I think Informix supports the standard TIMESTAMP and INTERVAL types so perhaps the write_tpeinfo_pm output from the Informix ODBC driver could supply the right values.
