select * from vi_ttnsmflwing t where t.flw_contime between to_date('2010-08-01 17:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2010-08-31 23:00:00','yyyy-mm-dd hh24:mi:ss') 为什么查到的记录还有14点的?
SELECT * FROM vi_ttnsmflwing t WHERE to_char(t.flw_contime, 'hh24:mi:ss') BETWEEN '17:00:00' AND '23:00:00' AND t.flw_contime BETWEEN DATE '2010-08-01' AND DATE '2010-09-01';
FROM vi_ttnsmflwing t
WHERE to_char(t.flw_contime, 'hh24:mi:ss') BETWEEN '17:00:00' AND
'23:00:00'
AND t.flw_contime BETWEEN DATE '2010-08-01' AND DATE '2010-09-01';