#sys.time_zone_info

[sqlchamp]

AT Time Zone – Convert timezone directly using SQL

AT Time Zone – Convert #timezone directly using #SQL #azure @SQLCHAMP Globalization brings new opportunities and enhance economic growth to any business, but along with all the goodness it also brings complexity to manage different time zones. One has to be always on toes to match different times. but what if you've got an application\code where you have to convert timezone within SQL Server data? If you are using SQL Azure Databases or SQL Server 2016 you don't have to worry about this trouble because Microsoft introduced this brand new function to make things easy for you: AT TIME ZONE; AT Time Zone This function converts an inputdate to target time zone as per your wish, isn't it cool. I am loving it, it simplified too many things. Now I don't have to write code\use dlls to convert date time – DST was the biggest issue and this function simply takes care of DST on its own. http://www.sqlchamp.com/2016/06/at-time-zone/206 http://www.sqlchamp.com/2016/06/at-time-zone/206