select to_char(post_date,'YYYY-MM-DD') 日期,count(*) 文件数 from tb where to_char(post_date,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD') or to_char(post_date,'YYYY-MM-DD')=to_char(sysdate-1,'YYYY-MM-DD') group by to_char(post_date,'YYYY-MM-DD')
SELECT COUNT(*),TO_CHAR(post_date,'YYYYMMDD') FROM TABLENAME WHERE TO_CHAR(post_date,'YYYYMMDD') BETWEEN TO_CHAR(SYSDATE-1,'YYYYMMDD') AND BETWEEN TO_CHAR(SYSDATE,'YYYYMMDD') ORDER BY TO_CHAR(post_date,'YYYYMMDD') ASC 第一条是昨天的,第二条是今天的
from tb
where to_char(post_date,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD')
or to_char(post_date,'YYYY-MM-DD')=to_char(sysdate-1,'YYYY-MM-DD')
group by to_char(post_date,'YYYY-MM-DD')
WHERE TO_CHAR(post_date,'YYYYMMDD') BETWEEN TO_CHAR(SYSDATE-1,'YYYYMMDD') AND BETWEEN TO_CHAR(SYSDATE,'YYYYMMDD')
ORDER BY TO_CHAR(post_date,'YYYYMMDD') ASC
第一条是昨天的,第二条是今天的