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?
Dateadd parameter sequence
Re: Dateadd parameter sequence
Thank you for the information. We have reproduced and fixed this issue. This fix will be included in the next UniDAC build.