oracle比較兩個時間

或者

to_char( date字段, 'HH24:MI:SS' ) >= '07:00:00' 
and to_char( date字段, 'HH24:MI:SS' ) <= '09:30:00'
           

如果是多個時間段，用or連接配接

to_char格式

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;   //日期轉化為字元串  
select to_char(sysdate,'yyyy')  as nowYear   from dual;   //擷取時間的年  
select to_char(sysdate,'mm')    as nowMonth  from dual;   //擷取時間的月  
select to_char(sysdate,'dd')    as nowDay    from dual;   //擷取時間的日  
select to_char(sysdate,'hh24')  as nowHour   from dual;   //擷取時間的時  
select to_char(sysdate,'mi')    as nowMinute from dual;   //擷取時間的分  
select to_char(sysdate,'ss')    as nowSecond from dual;   //擷取時間的秒