[Stackoverflow] [Progress OpenEdge ABL] Filtering a dataset by date and time Oracle SQL through Power BI

Status
Not open for further replies.
C

C.Mayers

Guest
I'm having trouble with filtering a date and time for anything two hours before and sooner. I tried this:

SELECT *
FROM
table
where
date >= sysdate - 1
AND
TO_DATE( Time, 'HH24:MI:SS' ) >= TO_DATE( sysdate, 'HH24:MI:SS' ) - 2


But I'm getting an inconsistent type error which is what I thought I was handling with the TO_DATE() function but I guess not.

I'm querying an Open Edge DB in Power BI.

Continue reading...
 
Status
Not open for further replies.
Top