How should I convert historic local time to UTC taking into account of daylight saving?
The main problem is the daylight saving doesn't occur at a fixed period every year and hence I cannot think of a way to do this task.
How should I convert historic local time to UTC taking into account of daylight saving?
The main problem is the daylight saving doesn't occur at a fixed period every year and hence I cannot think of a way to do this task.
See https://github.com/mj1856/SqlServerTimeZoneSupport by Matt Johnson for Sql Server 2008R2+.