Dateadd parameter sequence
Posted: 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?
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?