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’)