Hot questions by posting day of week/time (network-wide)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

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)

Enter Parameters

Options:
Switch sites
loading Hold tight while we fetch your results