0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT
  DATEADD(hour, DATEDIFF(hour, 0, CreationDate), 0) AS Hour,
  COUNT(*) AS NumberOfPosts
FROM
  Posts
WHERE
  CreationDate > DATEADD(week, -40, 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 12 anonymous

created apr 3 Johannes.Wachs