What to do with DATETIMEOFFSET?

Posted by GavinPayneUK on SQL Blogcasts See other posts from SQL Blogcasts or by GavinPayneUK
Published on Tue, 11 Jan 2011 22:15:16 GMT Indexed on 2011/01/11 22:56 UTC
Read the original article Hit count: 193

Filed under:
Someone asked me today if the time zone of a specific instance of SQL Server could be changed to match the country which that instance served. Some database products allow you to set this at an engine level which made me wonder if your data’s time fields “move” with the time zone setting of the database server instance?  If something was logged as happening at 9am Paris time it happened then, if I change my database server parameters did that event now happen at 9am New York time?  Perhaps...(read more)

© SQL Blogcasts or respective owner