Oracle选择某一时间段中的数据

如题..

tm 字段格式：yyyy-mm-dd hh24-mi-ss

 

这里给出两种方法

SELECT t.dt, t.tm, round(t.iopv, 2), t.* from etf.iopv t
where t.tm>='2012-11-20 09:20:00' AND t.tm<='2012-11-20 09:45:00'
ORDER BY t.tm DESC;

 

SELECT t.tm, round(t.iopv, 2), round(t.iopv_hk, 2), t.iopv, t.iopv_hk
FROM  etf.iopv t
WHERE  t.dt = trunc(SYSDATE)-1
        AND SUBSTR(t.tm, 12, 8) >= '09:30:00'
        AND SUBSTR(t.tm, 12, 8) <= '09:41:00'
ORDER BY t.tm DESC;

;