Laurette Cisneros wrote:
>
> Repost...sorry if it goes to the list twice.
>
> We are seeing a problem with the ODBC driver.
>
> Using this table:
>
> create table tst
> ( col1 date,
> col2 time);
>
> and inserting values (rows) into the date and time columns.
>
> 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
> wrong).
If you are using 7.01.0007 you can turn on the Mylog
option using ODBC DataSource Administrator.
Please send me the Mylog output for debug.
regards,
Hiroshi Inoue