SQLDescribeCol not returning correct information for time fields

From: Scott Ferrett <scott(at)ferrettconsulting(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLDescribeCol not returning correct information for time fields
Date: 2016-03-04 07:07:26
Message-ID: 56D9342E.30801@ferrettconsulting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


According to
https://msdn.microsoft.com/en-us/library/ms709314%28v=vs.85%29.aspx,
SQLDescribeCol should return "The number of digits to the right of the
decimal point in the seconds part of the value (fractional seconds).
This number cannot be negative." for datetime fields. The 32bit
PostgreSQL ODBC Driver(ANSI) version 9.05.01.00 always returns 0
regardless of the precision defined for a time or timestamp fields.

Cheers,
Scott Ferrett

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2016-03-04 18:19:45 Re: Obtaining hundredths of a second data from time data types
Previous Message Scott Ferrett 2016-03-04 06:39:39 Obtaining hundredths of a second data from time data types