convert historic local time to UTC taking into account of daylight saving

Question

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.

Flagged as a duplicate. Notice this answer specific to SQL 2016+ — James Jenkins, Mar 18 '19 at 16:42

score 2 · Accepted Answer · answered Jun 22 '16 at 09:11

2

answered Jun 22 '16 at 09:11

Serg

do we have anything similar to from_tz of oracle in SQL Server or any other builtin function that does the job? – Prashant Bhanarkar Jun 24 '16 at 04:46
Really from_tz only marks datetime with the timezone. Operator for converting the value is AT TIME ZONE . It was introduced in Sql Server 2016. – Serg Jun 24 '16 at 07:07

1 Answers1