The SWITCHOFFSET function returns a datetimeoffset value that has been altered from the stored time zone offset to a new time zone offset that has
Tag: SQL Server DATEADD function
SQL Server – Date Time Functions
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.