What time of day do I post questions and answers most?
Q&A about the site for people interested in the history and origins of science and mathematics
-- My Activity by UTC Hour -- What time of day do I post questions and answers most? SELECT datepart(hour,creationdate) AS hour, count(CASE WHEN posttypeid = 1 THEN 1 END) AS questions, count(CASE WHEN posttypeid = 2 THEN 1 END) AS answers FROM posts WHERE posttypeid IN (1,2) AND OwnerUserId=##UserID## GROUP BY datepart(hour,creationdate) ORDER BY hour