How to count the time diff?

[oceanju]

I have a table with a date type column.I want to query the record that less more 3 hours,how to do?
select * from tablename where systime - ltime > 3
?
please help.

[SANJAY_G]

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