-- 查询前1个小时到后一个小时之间的数据
SELECT
 ACCOUNT,NAME,CONTACT_NO
FROM
 CHECK_CUSTOMER_LIST
WHERE
 TO_CHAR(CRTE_DATE,'hh24:mi:ss') >= (TO_CHAR(SYSDATE,'hh24') -1 )
 ||':00:00'
AND TO_CHAR(CRTE_DATE,'hh24:mi:ss') < TO_CHAR(SYSDATE,'hh24')
 ||':00:00'
AND TO_CHAR(CRTE_DATE,'yyyy-MM-dd') = TO_CHAR(SYSDATE,'yyyy-MM-dd');