Oracle SQL group by day/week/month/quarter

You can choose any of the following options and replace the text string in SQLs to let the reports be as daily/weekly/monthly/Quarterly reports..

--daily

to_char(rad.created_on+15/24, 'YYYY-MM-DD')

--weekly

to_char(next_day(rad.created_on+15/24 - 7,2),'YYYY-MM-DD')

to_char(时间列,'yyyy')||to_char(时间列,'IW')  

--monthly

to_char(rad.created_on+15/24,'yyyy-mm')

--quarterly

to_char(rad.created_on+15/24,'yyyy-q') ||'Q'