I was doing some work recently where I needed to group some data from SQL Server by year, month, week, etc. The simplified version was something like this: SELECT COUNT(x), YEAR(CreatedUtc) FROM dbo.[Order] GROUP BY YEAR(CreatedUtc)The CreatedUtc data type is datetimeoffset storing zulu datetimes. Even