Skip site navigation (1) Skip section navigation (2)

Re: time problem with postgres ODBC driver (fwd)

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: time problem with postgres ODBC driver (fwd)
Date: 2002-02-14 17:28:34
Message-ID: Pine.LNX.4.33.0202140927410.29880-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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


In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-02-18 06:26:24
Subject: ODBC changes
Previous:From: Hiroshi InoueDate: 2002-02-14 16:53:25
Subject: Re: time problem with postgres ODBC driver (fwd)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group