Recently, I've needed to to do a number of conversions between UTC and local times within SQL Server. When I first looked into this I struggled to find clear explanations for going from UTC to local or from local to UTC - perhaps in part because at time