-- 查询昨天09点到今天09点的数据 SELECT ID,NAME,CONTACT_NO,ACCOUNT,TO_CHAR(crte_date,'dd-MM-yyyy'),'hh24:mi:ss') FROM CHECK_CUSTOMER_LIST WHERE CRTE_DATE >= (TRUNC(SYSDATE)+ 09/24)-1 AND CRTE_DATE < (TRUNC(SYSDATE)+ 09/24);
-- 查询昨天09点到今天09点的数据 SELECT ID,NAME,CONTACT_NO,ACCOUNT,TO_CHAR(crte_date,'dd-MM-yyyy'),'hh24:mi:ss') FROM CHECK_CUSTOMER_LIST WHERE CRTE_DATE >= (TRUNC(SYSDATE)+ 09/24)-1 AND CRTE_DATE < (TRUNC(SYSDATE)+ 09/24);
