SQL语句统计每小时，每天、每月、每年的_数据

--by hours
SELECT TO_CHAR(oper_time, 'hh24') AS "Each HOUR", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY TO_CHAR(oper_time, 'hh24')
 
--by day
SELECT TO_CHAR(oper_time,'DD')AS "Each day", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY  TO_CHAR(oper_time,'DD')
 
  --by week
SELECT TO_CHAR(oper_time,'iw')AS "Each Week", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY  TO_CHAR(oper_time,'iw')


 --by month
SELECT TO_CHAR(oper_time,'MM')AS "Each MOnth", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY  TO_CHAR(oper_time,'MM')


--by quart
SELECT TO_CHAR(oper_time,'q')AS "Each MOnth", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY  TO_CHAR(oper_time,'q')


--by year
--by quart
SELECT TO_CHAR(oper_time,'YYYY')AS "Each MOnth", COUNT(id) AS qty
FROM T_SYS_OPER_LOG  
WHERE  oper_time  BETWEEN TO_DATE('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND TO_DATE('2014-12-31 23:59:59','yyyy-mm-dd hh24:mi:ss') 
GROUP BY  TO_CHAR(oper_time,'YYYY')