Q&A for Ubuntu users and developers
-- 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)