O'Reilly logo
  • Dustin Waybright thinks this is interesting:

You then update the new attribute to the expression TODATETIMEOFFSET(dt, theoffset), and then drop the original attributes dt and theoffset from the table.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Used to convert non-offset aware dates to offset aware dates.