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