sgoley / DirectQuery-for-ODBC-in-PowerBI

Direct Query for PostgreSQL via ODBC with SSL
MIT License
14 stars 9 forks source link

PostgreSQL Date / Date Intervals #8

Open sgoley opened 5 years ago

sgoley commented 5 years ago

In latest version of connector, driver is not supporting conversion of SQL_TSI_DAY operator to pgsql compatible dateadd / datediff format. Operator is being interpreted as column name.

Lines 400->450 of the following log: mylog_Microsoft_17292.log

I have raised this as an issue with the psqlODBC project mailing list - https://www.postgresql.org/list/pgsql-odbc/