Oracle 23c

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

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';
CREATE TABLE TIME_TEST(tran_data_timestamp timestamp)
insert into time_test values(TIMESTAMP '2023-12-07 00:01:55.000000000');
1 rows affected

insert into time_test values(TIMESTAMP '2023-12-07 00:01:33.000000000');
1 rows affected

select * 
from   time_test 
where  tran_data_timestamp > TIMESTAMP '2023-12-06 00:02:25.000000'
and    tran_data_timestamp <= TIMESTAMP '2023-12-07 12:00:50.000000'


TRAN_DATA_TIMESTAMP


2023-12-07 00:01:55.000000

2023-12-07 00:01:33.000000