T-SQL supports two functions related to date and time values with an offset: SWITCHOFFSET and TODATETIMEOFFSET.
- 2. Getting Started with the SELECT Statement
- from Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012
- Publisher: Microsoft Press
- Released: December 2012
Offset refers to the number of hours/minutes off 0 UTC. UTC is at 0 in England. Offset for the Eastern United States is -5. OFFSET is used to store dates and times in a time zone other than the local system time zone or to choose a time zone for data in system that is not offset aware.
Share this highlighthttp://www.safaribooksonline.com/a/training-kit-exam/56851/