Laurette Cisneros <laurette(at)nextbus(dot)com> writes:
> create table tst
> ( col1 date,
> col2 time);
> When using the PostreSQL ODBC driver version 07.01.0007 against both a 7.2
> and 7.1.3 database server, a select * from tst returns the date value for
> col1 correctly, but returns the current date for col2 (which obviously is
It sounds like ODBC (or the client application) is misinterpreting the
datatype of col2 as being a "date" or "date/time" type not "time of
day". There is a translation between PG internal types and the ODBC
standard's notion of types, so one possible explanation is that there's
something getting lost in translation.
> Interestingly, we have a system that has (had) a driver we had
> downloaded from GreatBridge ODBC and it was working fine until we
> installed the PostgreSQL driver onto it.
This, however, mystifies me. AFAIK GB's ODBC driver wasn't different
from the community's.
regards, tom lane
In response to
pgsql-odbc by date
|Next:||From: Laurette Cisneros||Date: 2002-02-12 18:24:48|
|Subject: Re: time problem with postgres ODBC driver (fwd) |
|Previous:||From: Laurette Cisneros||Date: 2002-02-12 17:43:12|
|Subject: time problem with postgres ODBC driver (fwd)|