Re: time problem with postgres ODBC driver (fwd)

Same problem with either time or timestamp. Is these examples evtime is
timestamp but returns today's date. Sorry for the confusion.

On Fri, 15 Feb 2002, Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: Laurette Cisneros [mailto:laurette(at)nextbus(dot)com]
> >
> > And to add a bit more to the data gathered for this problem. I installed
> > the latest driver (7.01.00.09) and turned on "MyLog(Debug output)".
> >
> > I have attached the "MyLog" output for the two problems:
> >
> > 1) The mylog_1052.log file is for #1 below (the time gets returned
> > correctly).
> >
> > 2) The mylog_692.log file is for #2 below (the time gets retured as
> > today's date).
> >
>
> What column is of type TIME ?
> positions.evtime seems to be of type TIMESTAMP.
>
> regards,
> Hiroshi Inoue
>

--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere