- -- 查询昨天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);
