SQL Serverの時間分割統計

  --     
  select DATEADD(HOUR, DATEDIFF(HOUR,0,[Date]), 0) as EnterDate,sum([count])
  FROM Table1
  where
   roleid = 3 and 
  [Date] > '2012-7-26 20:00:00.00'
  group by DATEADD(HOUR, DATEDIFF(HOUR,0,[Date]), 0)
  order by [Date] desc

　
 
SQL Server DATEADD()関数
DATEADD()関数は、指定した間隔を日付に追加または減算します.

DATEADD(datepart,number,date)
date            。number           ；       ，     ，       ，     。datepart         。

SQL Server DATEDIFF()関数
DATEDIFF()関数は、2つの日付の間隔を返します.

DATEDIFF(datepart,startdate,enddate)

startdateパラメータとenddateパラメータは合法的な日付式です.
例:

1  SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate
   1 
2  SELECT DATEDIFF(hour,'2008-12-30 01:00:00','2008-12-30 01:04:00') AS DiffDate
   0 
3  SELECT DATEDIFF(minute,'2008-12-30 01:00:00','2008-12-30 01:04:00') AS DiffDate
   4

転載先:https://www.cnblogs.com/andy-2014/p/11427998.html