What to do with DATETIMEOFFSET?
- by GavinPayneUK
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)