Switching the offset for a UTC date in SQL Server 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(