question

sparky avatar image
sparky asked

How can I display all the time zone times and their descriptions in SQL 2014?

I want the ability to display the Time for the different time zones thru-out the world where I have clients. Is there a way to accomplish this in SQL-2014. Example: USA CST Central Time Zone 1:00pm, USA Mountain Time 12:00pm,
sql server 2014sql-server-2014timesql-server-centraltimezone
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
srutzky avatar image
srutzky answered
SQL Server has absolutely no concept of Time Zones prior to SQL Server 2016. If you need to do any conversions between time zones, especially conversions that are Daylight Saving-aware, then you should use Matt Johnson's [SQL Server Time Zone Support][1] project. [1]: https://github.com/mj1856/SqlServerTimeZoneSupport#sql-server-time-zone-support
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.