Question

查找oracle一定时间范围的sql语句怎么写

Answer 1

where dt between
to_date('2005-05-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and
to_date('2005-08-08 00:00:00', 'yyyy-mm-dd hh24:mi:ss')

Answer 2

使用to_char()将时间字段转换成字符串然后再做。例如
select
*
from
table1
where
to_char(t,'hh24')>=8
and
to_char(t,'hh24')<17