Re: Obtaining hundredths of a second data from time data types

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Scott Ferrett <scott(at)ferrettconsulting(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Obtaining hundredths of a second data from time data types
Date: 2016-03-09 10:24:26
Message-ID: 56DFF9DA.1090804@dream.email.ne.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Silvio Brandani 2016-03-09 10:46:59 problems changing postgres jdbc driver
Previous Message Scott Ferrett 2016-03-09 00:34:28 Re: Obtaining hundredths of a second data from time data types