August 23, 2016 at 9:40 pm
Comments posted to this topic are about the item Time zones
August 23, 2016 at 11:18 pm
This was removed by the editor as SPAM
August 24, 2016 at 1:51 am
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 24, 2016 at 2:27 am
Got the wrong answer, but that's because I pretty much clicked at random...I wanted to know the actual answer and my Google-fu failed me in finding it. Odd that functionality like this is only just being introduced in SQL 2016, though, I imagine it would have been useful a long time ago!
August 24, 2016 at 6:23 am
paul.knibbs (8/24/2016)
Got the wrong answer, but that's because I pretty much clicked at random...I wanted to know the actual answer and my Google-fu failed me in finding it. Odd that functionality like this is only just being introduced in SQL 2016, though, I imagine it would have been useful a long time ago!
Maybe is a little bit confusing that in the MSDN documentation
for sys.time_zone_info (Transact-SQL) is incorrectly specified:
"Applies To: "SQL Server (starting with 2008)".
Nice one, thanks Steve.
August 24, 2016 at 7:03 am
Had to look this one up as we are still on 2008R2.
August 24, 2016 at 7:33 am
There is a related function 'At Time Zone' that is also useful:
August 24, 2016 at 8:12 am
Great question Steve. And a topic I had not yet seen. Thanks.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 24, 2016 at 11:17 am
Nice question.and it's rather easy to arrive at the correct answer.
However, people should be beware of sys.time_zone_info because Microsoft have screwed up the time zones (both in sys.time_zone_info and in the registry: KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones). They've omitted West European Time and invented an imaginary zone West European Standard Time which is identical to Central European Time. I image this is because someone misinterpreted the acronym WEST (S for Summer, not S for standard) which refers to WET+1 used in summer in the WET zone areas other than Iceland (ie it is the time used in summer in the parts of the WET zone that have "daylight saving time") and nobody at Microsoft bothered to check this (which could have been done very easily by looking at the page referenced in the first answer option, or by looking in wikipedia or at any decent encyclopedia). I can imagine chaos resulting from people looking for West European Time in the MS data, finding West European Standard Time, assuming that's what they want, and assigning the wrong offset for Dublin, Lisbon, London, Las Palmas, Reykjavík, Tórshavn and so on, thus being an hour out (MS's W European Standard Time is currently UTC+2, while everywhere in the West European zone is currently at UTC+1, except Iceland which doesn't use summer time and is currently UTC+0).
Tom
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply