SQLblog.com - The SQL Server blog spot on the web
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 year (here in the US, the time occurs on the first Sunday of November). Unless you live in London, England or someplace where the offset from UTC is 0,...(read more)
No comments:
Post a Comment