Dateadd parameter sequence

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

Dateadd parameter sequence

Post by albourgz » Thu 17 Nov 2016 16:25

Hi,
postgres: select {fn DATEADD(HOUR,2,localtimestamp ) } works
oracle: select {fn DATEADD(HOUR,2,sysdate ) } from dual fails, have to type select {fn DATEADD(HOUR,sysdate,2 ) }

This means the sequence of the parameters has to be changed according to database type.
Any fix/hint?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Dateadd parameter sequence

Post by azyk » Fri 18 Nov 2016 10:20

Thank you for the information. We have reproduced and fixed this issue. This fix will be included in the next UniDAC build.

Post Reply