按周，显示每天（只是出现了有记录的天数）近半年，显示每月（只是出现了有记录的天数）按月，显示每周（只是出现了有记录的天数）

-- 按周，显示每天（只是出现了有记录的天数）
select to_char(REGISTERTIME,'yyyy-mm-dd') years ,count(ACCOUNTID) counts from T_ACCOUNT where REGISTERTIME > sysdate - (to_char(sysdate,'D')) and PERMISSIONID=4
group by to_char(REGISTERTIME,'yyyy-mm-dd')
order by to_char(REGISTERTIME,'yyyy-mm-dd');

--貌似这个才是正确的显示每天
select to_char(REGISTERTIME,'yyyy-mm-DD') weekyears ,count(REGISTERTIME) weekcounts
from T_ACCOUNT
where to_date(REGISTERTIME)>=to_date(sysdate-to_number(to_char(sysdate-1,'D')+1)) and PERMISSIONID=4
group by to_char(REGISTERTIME,'yyyy-mm-DD')
order by to_char(REGISTERTIME,'yyyy-mm-DD');



--近半年，显示每月（只是出现了有记录的天数）
select to_char(t.REGISTERTIME,'MM') hrefMonths,count(0) hrefCounts from T_ACCOUNT t where t.REGISTERTIME>trunc(add_months(sysdate,-6),'mm')  and PERMISSIONID=4 group by to_char(REGISTERTIME,'MM') order by to_char(REGISTERTIME,'MM');


--按月，显示每周（只是出现了有记录的天数）
select to_char(t.REGISTERTIME,'YYYY') YEAR,TO_CHAR(t.REGISTERTIME,'IW') TIME,COUNT(*) COUNT from T_ACCOUNT t where  PERMISSIONID=4                                                                                   AND T.REGISTERTIME>TRUNC(ADD_MONTHS(SYSDATE,0),'mm')
GROUP BY TO_CHAR(t.REGISTERTIME,'IW'),to_char(t.REGISTERTIME,'YYYY');