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 |
select *
from time_test
where tran_data_timestamp > TIMESTAMP '2023-12-06 00:02:25.000000'
and tran_data_timestamp <= TIMESTAMP '2023-12-07 00:01:50.000000'
| TRAN_DATA_TIMESTAMP |
|---|
| 2023-12-07 00:01:33.000000 |