What time of day do I post questions and answers most?
Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática
-- 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