如题..
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;
;