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...
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...