CODEWITHSUNDEEP
azuretimezoneazure-data-factorydst
Kermit754
Kermit754

Reputation: 343

Azure data factory convert timestamp taking into account DST

I have a data flow in Azure Data Factory The source contains timestamps in local time The sink is a SQL that is running on UTC

In the DataFlow, I can convert the timestamp to UTC using the following command

toUTC(timestamp, "Romance Standard Time")

But that does not take into account DST.

Is there a way to do this directly in the dataflow ?

Upvotes: 3

Views: 3321

Answers (1)

Matt Johnson-Pint
Matt Johnson-Pint

Reputation: 241485

The toUTC function should indeed take into account DST, as well as other historical changes to time zone offsets.

According to the documentation, the supported time zones are those used by Java, which would be the regular IANA time zones (plus a few extra abbreviations for Java legacy purposes).

"Romance Standard Time" is a Windows time zone identifier. An equivalent IANA zone that should work with ADF would be "Europe/Paris". Refer to the CLDR mapping here.

(If you need to do this mapping in .NET code, use my TimeZoneConverter library.)

Upvotes: 2

Related Questions