Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver

Поиск
Список
Период
Сортировка
От Inoue, Hiroshi
Тема Re: Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver
Дата
Msg-id 8bb90490-e765-6831-42b0-3939a04b42d5@dream.email.ne.jp
обсуждение исходный текст
Ответ на Regarding conversion of SQL_TSI_DAY operator for Datetimeadd function in ODBC driver  (Scott Goley <scottmgoley@gmail.com>)
Ответы Re: Regarding conversion of SQL_TSI_DAY operator forDatetimeadd function in ODBC driver
Список pgsql-odbc
Дерево обсуждения
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
Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Xuesong Gao
Дата:
Сообщение: RE: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255
Следующее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: psqlodbc - table name is truncated to 127 characters evenSQL_MAX_TABLE_NAME_LEN is set to 255