Problems about ODBC3 datetime - Mailing list pgsql-odbc

From Han
Subject Problems about ODBC3 datetime
Date
Msg-id 20021121065238.3CE824758FE@postgresql.org
Whole thread Raw
Responses Re: Problems about ODBC3 datetime
List pgsql-odbc
Hi,
    Firstly, I encountered a problem when using SQL_DATE: when I use SQLGetTypeInfo(...,SQL_DATE);
the API returns no record. I debuged the psqlodbc driver and found that the value of the parameter DataType was 91. So
Ithink that the value was changed by the odbc30 Driver Manager. But why don't the psqlodbc add the SQL_TYPE_DATE and
otherODBC30 data types support in the array sqlTypes[](in pgtypes.c)? 
    Secondly, I wander why returning SQL_DATETIME in function pgtype_to_sqldesctype for the three types--SQL_TYPE_DATE,
SQL_TYPE_TIME,SQL_TYPE_TIMESTAMP? 
    Thanks!!!



        


        Han
        zhouhanok@vip.sina.com
          2002-11-21




pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: PostgreSQL+ Beta bug?
Next
From: "Henshall, Stuart - Design & Print"
Date:
Subject: empty text on XP in MS Access