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

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

Hi Hiroshi,

That driver passed all my tests. Thanks.

Cheers,
Scott

On 09/03/2016 21:24, Inoue, Hiroshi wrote:
> 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2016-03-09 13:04:56 Re: Fwd: problems changing postgres jdbc driver
Previous Message Silvio Brandani 2016-03-09 11:29:18 Re: Fwd: problems changing postgres jdbc driver