SQLblog.com - The SQL Server blog spot on the web
Using AT TIME ZONE to manipulate and convert time zones
I have a series of blogs about temporal tables in SQL Server 2016, which you can see here . However, one thing I never had mentioned was that the Temporal Row Start and End Times are always stored in UTC times (which is generally inconvenient to work with unless you are from the Great Britain area). However, when you are looking at your data and want to see what the data looked like at 'Yesterday at 12:00 at the computer you are working from, this can be a bit more work. In 2016 SQL Server,...(read more)
No comments:
Post a Comment