I have to get local date data across many servers scattered around the globe and identify whether it is in daylight saving mode or not ?
Need help.
Sql-server – Identify whether the given servers time is in daylight saving or not
sql server
Related Question
- Sql-server – Advice needed for Querying DateTimeOffset data by end users
- Sql-server – Check the data latency between two Always On Availability Group servers in ASYNC mode
- SQL Server 2014 SSMS – Registered Servers with ReadOnly Application Intent
- Sql-server – Need to maintain transactional consistency of the data across both servers, need to achieve these goals without manual intervention
- Sql-server – Check difference between results not listed and identify which day is the date
- SQL Server – Improving Performance of Daylight Saving Lookup Table
- Sql-server – MSX Job deployment: Not creating job on certain servers
Best Answer
This is solved in SQL Server 2016 with AT TIME ZONE. And I wrote an article about it here: http://sqlperformance.com/2016/07/sql-plan/at-time-zone
In earlier versions you'll probably need some CLR to read that information from the registry.