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.
Printable View
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.
Code:SELECT * FROM table_name WHERE column_name > SYSDATE-1/8;