Oracle 18c

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