0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

DECLARE @StartDate datetime = ##StartDate:string##;
DECLARE @EndDate datetime = ##EndDate:string##;

SELECT 
  DATEADD(HOUR, DATEDIFF(HOUR, 0, CreationDate), 0),
  COUNT(*)
  FROM posts
  WHERE posttypeid = 1
    AND creationdate BETWEEN @StartDate AND @EndDate
  GROUP BY DATEADD(HOUR, DATEDIFF(HOUR, 0, CreationDate), 0)
  ORDER BY DATEADD(HOUR, DATEDIFF(HOUR, 0, CreationDate), 0)

view current version

edited mar 14 21

created mar 14 21 Glorfindel