SELECT * FROM TABLE WHERE to_number(to_char(TARGET_DATE,'hh24miss')) BETWEEN 180000 AND 190000 AND TARGET_DATE BETWEEN to_date('20110501','yyyymmdd') AND to_date('20110530235959','yyyymmddhh24miss')
select * from tab where sj>=to_date('2011-05-01','yyyy-mm-dd') and sj<=to_date(2011-05-30','yyyy-mm-dd') and (to_char(sj,'hh24:mi:ss') between '18:00:00' and '19:00:00')
AND TARGET_DATE BETWEEN to_date('20110501','yyyymmdd') AND to_date('20110530235959','yyyymmddhh24miss')
sj<=to_date(2011-05-30','yyyy-mm-dd') and (to_char(sj,'hh24:mi:ss') between '18:00:00' and '19:00:00')