半小时内
select * from table where sysdate-1/48 <= column
一小时内
select * from table where sysdate-1/24 <= column
一天内
select * from table where sysdate-1 <= column
半小时内
select * from table where sysdate-1/48 <= column
一小时内
select * from table where sysdate-1/24 <= column
一天内
select * from table where sysdate-1 <= column