-- 查询昨天09点到今天09点的数据
SELECT
ID,
NAME,
CONTACT_NO,
ACCOUNT,
TO_CHAR(crte_date,'dd-MM-yyyy'),
TO_CHAR(crte_date,'hh24:mi:ss')
FROM
CHECK_CUSTOMER_LIST
WHERE
CRTE_DATE >= (TRUNC(SYSDATE)+ 09/24)-1
AND CRTE_DATE < (TRUNC(SYSDATE)+ 09/24);
Oracle查询昨天09点到今天09点的数据
最新推荐文章于 2024-07-31 17:45:58 发布