Oracle 时间分组

SELECT T.OPE_NAME, T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE, 'hh24'),TRUNC(T.CREATION_DATE, 'hh24')+1/24 ,COUNT(1) /*to_char(T.CREATION_DATE,'yyyymmdd hh24:mi:ss')*/
  FROM T_OPE_ACCOUNT T
 GROUP BY T.OPE_NAME, T.OPE_IDENTIFY, TRUNC(T.CREATION_DATE, 'hh24') 


SELECT T.OPE_NAME, T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE, 'mi'),TRUNC(T.CREATION_DATE, 'mi')+1/(24*60)  ,COUNT(1)  --1/(24*60) 
  FROM T_OPE_ACCOUNT T
 GROUP BY T.OPE_NAME, T.OPE_IDENTIFY, TRUNC(T.CREATION_DATE, 'mi') 
 
 SELECT T.OPE_NAME, T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE, 'dd'),TRUNC(T.CREATION_DATE, 'dd')+1 ,COUNT(1)
  FROM T_OPE_ACCOUNT T
 GROUP BY T.OPE_NAME, T.OPE_IDENTIFY, TRUNC(T.CREATION_DATE, 'dd') 
 
  SELECT T.OPE_NAME, T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE, 'mm') ,COUNT(1),
      ADD_MONTHS(TRUNC(T.CREATION_DATE, 'mm'),1) 
  FROM T_OPE_ACCOUNT T
 GROUP BY T.OPE_NAME, T.OPE_IDENTIFY, TRUNC(T.CREATION_DATE, 'mm')