Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Date
Msg-id 8bb90490-e765-6831-42b0-3939a04b42d5@dream.email.ne.jp
Whole thread Raw
In response to Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver  (Scott Goley <scottmgoley@gmail.com>)
Responses Re: Regarding conversion of SQL_TSI_DAY operator forDatetimeadd function in ODBC driver  (Scott Goley <scottmgoley@gmail.com>)
List pgsql-odbc
Tree view
Hi Scott,

Unfortunately neither TIMESTAMPADD() nor TIMESTAMPDIFF() is supported now.
Could you please try test drivers which would support them?

regards,
Hiroshi Inoue

On 2019/08/09 0:00, Scott Goley wrote:
Hi,

Platform / Version info:

Postgres 11.4
psqlODBC_x64 v 11.01.0000

I'm a developer working with PowerQuery / ODBC and I'm running into the following issue.


I'm developing a custom connector which is utilizing this driver. I've attached the logs as requested when making a bug report. It looks like the SQL_TSI_DAY operator is being "interpreted" by the driver as a column reference rather than making the necessary conversion to the correct datetimeadd "interval" .

I'm attaching the connector file - ODBCPostgresDirect simply because it contains all the flags that I'm setting for SQLCapabilities, ODBC function overrides etc.

Any input on this would be helpful.

Best,
Scott

ウイルス フリー｡ www.avg.com
Attachment

pgsql-odbc by date:

Previous
From: Xuesong Gao
Date:
Subject: RE: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255