SQL SERVER – Datetime Function SWITCHOFFSET Example | Journey to SQL Authority with Pinal Dave

I was recently asked if I know how SWITCHOFFSET works. This feature only works in SQL Server 2008. Here is quick definition of the same from BOL: Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone

blog.sqlauthority.com