THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » AT TIME ZONE   (RSS)
  • Temporal Tables - Part 6 - Start and End Times in UTC Time Zone

    In my first 5 blogs on Temporal, I failed to note something pretty important about their usage. The start and end times for the row (and it follows, the historical rows) are likely not in your local time zone. They are stored in UTC time zone. This is obviously good because of that pesky daylight saving time issue where 1:30 AM occurs twice each ...
    Posted to Louis Davidson (Weblog) by drsql on September 17, 2017
  • 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 ...
    Posted to Louis Davidson (Weblog) by drsql on September 1, 2017
Privacy Statement