[Stackoverflow] [Progress OpenEdge ABL] Combining a date field and a time field in Progress Open edge SQL statement within Power BI

Status
Not open for further replies.
C

C.Mayers

Guest
So I have a query that I have been feverishly trying to get working and I feel like it should have been easy enough but I was very much wrong.

I have two fields that I'm trying to compare to the system date less two hours. So basically everything that has happened in the past two hours. The date is a date data type but the time is text data type.

Here is an example of one of the many ways I tried to execute it;

SELECT *
FROM
ExampleTable
WHERE
TO_DATE( DateField || ' ' || TimeField ) >= sysdate -(2/24)


I've also tried converting each field within the TO_DATE(), converting just the time, converting all of them and sysdate using TO_DATE and TO_TIMESTAMP and so many other variations. All the outputs throw an error of inconsistent data types.

Please assist if you can!

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