Re: Obtaining hundredths of a second data from time data types - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: Obtaining hundredths of a second data from time data types
Date
Msg-id 56DFF9DA.1090804@dream.email.ne.jp
Whole thread Raw
In response to Re: Obtaining hundredths of a second data from time data types  (Scott Ferrett <scott@ferrettconsulting.com>)
Responses Re: Obtaining hundredths of a second data from time data types  (Scott Ferrett <scott@ferrettconsulting.com>)
List pgsql-odbc
Hi Scott,

On 2016/03/09 9:34, Scott Ferrett wrote:
> Hi Hiroshi,
>
> This driver fixes all the problems with retrieving data.  Thank you.
>
> This allowed me to get further with my testing and found the next
> problem.
>
> Although you can now retrieve data using SQLBindCol, you cannot insert
> of update data using SQLBindParameter.
>
> If you issue an INSERT INTO TestTable (ID,T) VALUES (?,?) and use
> SQLBindParameter to bind an SQL_C_TIMESTAMP structure to the second
> parameter, then the new row is inserted with the fractional part
> truncated.

Please try the test drivers 9.5.0105 at
  http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Scott Ferrett
Date:
Subject: Re: Obtaining hundredths of a second data from time data types
Next
From: Silvio Brandani
Date:
Subject: problems changing postgres jdbc driver