0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT
  DATEADD(hour, DATEDIFF(hour, 0, CreationDate), 0) AS Hour,
  COUNT(*) AS NumberOfPosts
FROM
  Posts
WHERE
  CreationDate > DATEADD(week, -70, GETDATE())  AND PostTypeId = 1 -- This filters out posts older than 4 weeks
GROUP BY
  DATEADD(hour, DATEDIFF(hour, 0, CreationDate), 0)
ORDER BY
  Hour;

fork query

edited aug 12 anonymous

created apr 3 Johannes.Wachs