By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE myTable ( myDate TIMESTAMP(6) );
INSERT INTO myTable ( myDate )
SELECT SYSTIMESTAMP - ( LEVEL - 1 ) * INTERVAL '1' DAY
FROM DUAL
CONNECT BY LEVEL <= 15;
15 rows affected
SELECT SYSDATE - myDate as difference
FROM myTable
WHERE SYSDATE - myDate > INTERVAL '10' DAY;
| DIFFERENCE |
|---|
| +000000010 23:59:59.442552 |
| +000000011 23:59:59.442552 |
| +000000012 23:59:59.442552 |
| +000000013 23:59:59.442552 |
SELECT SYSDATE - myDate as difference
FROM myTable
WHERE SYSDATE - myDate > 10;
ORA-00932: inconsistent datatypes: expected INTERVAL DAY TO SECOND got NUMBER