SQL & PL/SQL

Hi,
I have table

create table t1 (id number,
start_time date,
end_time date);
insert into t1 values (1,to_date('06:30','hh24:mi'),to_date('14:00','hh24:mi'));
insert into t1 values (2,to_date('14:30','hh24:mi'),to_date('22:00','hh24:mi'));
insert into t1 values (3,to_date('22:30','hh24:mi'),to_date('06:00','hh24:mi'));

select * from t1;
id         start_time       end_time
1           06:30               14:00
2           14:30               22:00
3           22:30               06:30

I need to find the record where 05:00 hr exists.

Thanks

Edited by: benz on Mar 9, 2013 10:12 PM