SELECT * FROM TBNAME WHERE COL_TIME>SYSDATE-1/24;
SELECT TO_CHAR(SYSDATE,'HH24') FROM DUAL;//取当前小时
SELECT TO_CHAR(SYSDATE,'MI') FROM DUAL;//取当前分钟
SELECT TO_CHAR(SYSDATE,'HH24') FROM DUAL;//取当前小时
SELECT TO_CHAR(SYSDATE,'MI') FROM DUAL;//取当前分钟
SELECT * FROM TBNAME WHERE COL_TIME<SYSDATE-1/24;//这是一个小时以前的所有数据