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@nextbus.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
