QUERY to display data from certain time, i.e.FROM 8:30 a.m. yesterday TO 7:45 a.m. today

Oracle 19.22 database

I have a cronjob that run at 9 a.m. I would like to pull data from a table as follows"

Query1 = to get data FROM 8:30 a.m. Yesterday TO 7:45 a.m. today - using TIMESTAMP

and/or

Query2 =fetch last 24 hour data - using TIMESTAMP

Table:

DB_DAILY_TRANS
(
OS_USERNAME VARCHAR2(255 BYTE),
USERNAME VARCHAR2(128 BYTE),
USERHOST VARCHAR2(128 BYTE),
TIMESTAMP DATE,
OWNER VARCHAR2(128 BYTE),
OBJ_NAME VARCHAR2(128 BYTE),
ACTION NUMBER NOT NULL,
ACTION_NAME VARCHAR2(28 BYTE),
NEW_OWNER VARCHAR2(128 BYTE),
NEW_NAME VARCHAR2(128 BYTE),
TRANSACTIONID VARCHAR2(30 BYTE)