Code:
SELECT * FROM table_name WHERE column_name > SYSDATE-1/8;