Hi support team,
I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line
This is my original query from oracle
... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00:00:00','YYYY-MM-DD HH24:MI: SS')
Then I convert it to denodo format
... AND ADDHOUR(datedata, 8)>=TOTIMESTAMP('YYYY-MM-DD HH24:MI:SS', CAST(ADDHOUR(CURRENTDATE,16)-1, 'YYYY-MM-DD') || '00:00:00')
However, I get the error on this line *CAST(ADDHOUR(CURRENTDATE,16)-1*, it says **text invalid parameter types for function '-': timestamp, int**. How can I convert it to make it to fit my query, it also follows with an error **invalid parameter types for function '||': <unknown>**. Thank you for the help