SELECT *
FROM my_table
WHERE my_date_column BETWEEN (trunc(sysdate-1)+14/24) AND (trunc(sysdate)+15/24);