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

Hiroshi,

Thank you for your response. I will definitely look into that.
Is there any resource which specifies what functions and flags are supported via the current psqlODBC driver? That would be extremely helpful to me if you were aware of one.
Best,
Scott G

On Aug 9 2019, at 8:56 pm, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> wrote:
> 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 (https://link.getmailspring.com/link/A8B8CEE7-2F6D-4AE4-BE2A-658777E043C1(at)getmailspring(dot)com/1?redirect=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&recipient=cGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw%3D%3D)