Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (NAME, COMP_DATE) AS
SELECT 'Joe',    TIMESTAMP '2022-01-25 16:59:59.837000' FROM DUAL UNION ALL
SELECT 'Steve',  TIMESTAMP '2022-01-31 12:15:45.234224' FROM DUAL UNION ALL
SELECT 'James',  TIMESTAMP '2022-01-15 15:15:45.543400' FROM DUAL UNION ALL
SELECT 'Austin', TIMESTAMP '2022-01-17 14:15:14.334000' FROM DUAL;
4 rows affected

Select * from Table_name where comp_date != sysdate - 10.


NAME
COMP_DATE


Joe
25-JAN-22 16.59.59.837000000

Steve
31-JAN-22 12.15.45.234224000

James
15-JAN-22 15.15.45.543400000

Austin
17-JAN-22 14.15.14.334000000


Select * from Table_name where comp_date <> sysdate - 10.


NAME
COMP_DATE


Joe
25-JAN-22 16.59.59.837000000

Steve
31-JAN-22 12.15.45.234224000

James
15-JAN-22 15.15.45.543400000

Austin
17-JAN-22 14.15.14.334000000


ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'
SELECT TIMESTAMP '2022-02-04 16:59:59.837000' - 10. FROM DUAL;


TIMESTAMP'2022-02-0416:59:59.837000'-10.


2022-01-25 16:59:59


Select * from Table_name where comp_date != TIMESTAMP '2022-02-04 16:59:59.837000' - 10.


NAME
COMP_DATE


Joe
2022-01-25 16:59:59.837000000

Steve
2022-01-31 12:15:45.234224000

James
2022-01-15 15:15:45.543400000

Austin
2022-01-17 14:15:14.334000000


Select * from Table_name where comp_date <> TIMESTAMP '2022-02-04 16:59:59.837000' - 10.


NAME
COMP_DATE


Joe
2022-01-25 16:59:59.837000000

Steve
2022-01-31 12:15:45.234224000

James
2022-01-15 15:15:45.543400000

Austin
2022-01-17 14:15:14.334000000


Select *
from   Table_name
where  comp_date <> CAST(
                      CAST(
                        TIMESTAMP '2022-02-04 16:59:59.837000'
                        AS DATE
                      )
                      - 10.
                      AS TIMESTAMP
                    )


NAME
COMP_DATE


Joe
2022-01-25 16:59:59.837000000

Steve
2022-01-31 12:15:45.234224000

James
2022-01-15 15:15:45.543400000

Austin
2022-01-17 14:15:14.334000000


Select *
from   Table_name
where  comp_date != TIMESTAMP '2022-02-04 16:59:59.837000' - INTERVAL '10' DAY


NAME
COMP_DATE


Steve
2022-01-31 12:15:45.234224000

James
2022-01-15 15:15:45.543400000

Austin
2022-01-17 14:15:14.334000000


Select *
from   Table_name
where  comp_date <> TIMESTAMP '2022-02-04 16:59:59.837000' - INTERVAL '10' DAY


NAME
COMP_DATE


Steve
2022-01-31 12:15:45.234224000

James
2022-01-15 15:15:45.543400000

Austin
2022-01-17 14:15:14.334000000

NAME	COMP_DATE
Joe	25-JAN-22 16.59.59.837000000
Steve	31-JAN-22 12.15.45.234224000
James	15-JAN-22 15.15.45.543400000
Austin	17-JAN-22 14.15.14.334000000

NAME	COMP_DATE
Joe	2022-01-25 16:59:59.837000000
Steve	2022-01-31 12:15:45.234224000
James	2022-01-15 15:15:45.543400000
Austin	2022-01-17 14:15:14.334000000