1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- My Activity by UTC Hour
-- What time of day do I post comments most?
SELECT
 datepart(hour,c.creationdate) AS hour,
 count(*) AS comment_count
FROM comments c
WHERE
  c.UserId=##UserID##
GROUP BY datepart(hour,c.creationdate)
ORDER BY hour

fork query

edited aug 3 15

created aug 3 15 Deer Hunter