关于时间截取的问题!急

Question

http://community.csdn.net/Expert/topic/4681/4681649.xml?temp=.3760797

Answer 1

where TO_CHAR(rqsj,'HH24MI')>='0800' AND TO_CHAR(rqsj,'HH24')<='1300'
 AND TRUNC(rqsj)>=to_date('','yyyymmdd') and TRUNC(rqsj)<=to_date('','yyyymmdd') 
解决了，
这个比较不知道正确吗，再看看TO_CHAR(rqsj,'HH24MI')>='0800' AND TO_CHAR(rqsj,'HH24')<='1300'

Answer 2

TO_CHAR(rqsj,'HH24MI')>='0800' AND TO_CHAR(rqsj,'HH24MI')<='1300'
就可以了，后面那个也应该加上MI

Answer 3

where trunc(datetime) between to_date('2006-04-01','yyyy-mm-dd') and to_date('2006-04-03','yyyy-mm-dd') and to_char(datetime,'hh24:mi:ss') between '08:00:00' and '09:00:00'