how to group datetime into daily/hourly

• andrewd.smith

  SSCrazy Eights

  Points: 8444

  More actions

  March 23, 2011 at 2:19 pm

  #1302708

  You can group by the expression:

  DATEADD(hour, DATEDIFF(hour, 0, XDateTime), 0)

  e.g.

  SELECT

  DATEADD(hour, DATEDIFF(hour, 0, XDateTime), 0) AS XHour,

  AVG(XValue) AS XAvg

  FROM MyTable

  GROUP BY DATEADD(hour, DATEDIFF(hour, 0, XDateTime), 0)

  ORDER BY XHour