0

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.

1 Answers1

2

See https://github.com/mj1856/SqlServerTimeZoneSupport by Matt Johnson for Sql Server 2008R2+.

Serg
  • 1,266
  • 7
  • 12