Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language
-- At what hour do I ask most posts, both questions and answers?
-- UTC (GMT) time zone.
DECLARE @UserId int = ##UserId##
DECLARE @Part int = 0
DATEPART("hour", CreationDate) as [Hour you add a post],
COUNT(*) as [Number of your posts]
WHERE OwnerUserId = @UserId
GROUP BY DATEPART(hour, CreationDate)