sql

hi can someone give me a hint,
i want to get the data from yeaterday 2 pm to today 3 pm.

thanks

How about a hint of what columns are in the table to query against.

Gary

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