0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

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

fork query

edited aug 14

created apr 3 Johannes.Wachs