Convert UTC timezone to US

ADF_Coder 0

Hi All,

I need to convert the timezone from UTC to the US timezone. Can anyone please tell me what function I need to use: convertTimezone or convertfromutc? This is because my sharepoint is in the US time zone.

@convertTimeZone('2024-07-14T07:36:08.8384661Z','UTC','U.S. Mountain Standard Time')

2 answers

akinbade abiola 8,300 Reputation points

2024-07-14T17:50:37.3666667+00:00
Hello ADF_Coder,

Thanks for your your question.
Your usage seems correct. You can also test the below:

SELECT CONVERT(datetimeoffset, '2024-07-14T07:36:08.8384661Z') AT TIME ZONE 'UTC' AT TIME ZONE 'US Mountain Standard Time' AS 'US_Mountain_Time';

You can mark it 'Accept Answer' if this helped.

Regards,

Abiola
Please sign in to rate this answer.
ADF_Coder 0 Reputation points

2024-07-14T17:54:33.7233333+00:00

@akinbade abiola ,

Thank you for reply.

Pipeline is failing with below error:

In the function 'convertTimeZone', the value provided for the time zone id 'U.S. Mountain Standard Time' was not valid. '.

Erland Sommarskog 106.2K Reputation points MVP

2024-07-14T18:57:01.1733333+00:00

I don't know Azure Data Factory, but I googled converttimezone azure data factory. That took me to https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions. I searched in the browser for converttimezone and there was a link and I ended up at https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#convertTimeZone. I saw this:

If you take this route and click on Microsoft Time Zone Values, you should find the answer. (My guess is that you should take out the dots, but I did not check.)

ADF_Coder 0 Reputation points

2024-07-15T04:16:35.75+00:00

Hi @akinbade abiola , @Erland Sommarskog , @e

I have below scenario.

I have one pipeline where I am checking first the (pipeline trigger time - 1 Day) and storing the value in one variable.

And then I am checking the files at Sharepoint. If there is any file for the previous day, then I am extracting the files.

The issue here is my ADF pipeline trigger time(). It is in UTC format.

and my sharepoint is in the US time zone.

Currently, I am using the below logic without handling timezones.

Can anyone help me with the logic of timezone conversion with daylight saving?

@subtractFromTime(pipeline().TriggerTime,1,'Day')
Sign in to comment
NIKHILANETHIKUNTA 75 Reputation points Microsoft Vendor

2024-07-17T08:18:04.14+00:00
Hi @ADF_Coder
Thanks for your question and using Microsoft Q&A platform.

Azure Data Factory (ADF) uses UTC time zone by default. If you want to convert it to a specific time zone, you can use the convertFromUtc function in ADF.
You can try this expression:

@convertFromUtc(utcnow(),'Mountain Standard Time')

This will convert the UTC time to US time.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
ADF_Coder 0 Reputation points

2024-07-17T09:26:57.6033333+00:00

Hi @NIKHILANETHIKUNTA ,

My question is different. Also, UTC will handle daylight saving? Can you please confirm?

Erland Sommarskog 106.2K Reputation points MVP

2024-07-17T09:32:18.13+00:00

UTC is UTC and does not come with any daylight savings time. UTC is the time from which all other time zones are defined. Mountain Standard Time is UTC+07:00 in winter time and UTC+06:00 in summer time.

PS Please be careful to select the correct input box. Answer is for answers to the original comment, and you would only use Answers if you find the solution yourself. I converted your Answer to a Comment.

NIKHILANETHIKUNTA 75 Reputation points Microsoft Vendor

2024-07-17T10:18:18.7633333+00:00

Hi @ADF_Coder
Yes. convertFromUtc will automatically handle daylight saving time adjustments, as long as the time zone that you are targeting uses daylight saving time. When performing the conversion, the ConvertTimeFromUtc method applies any adjustment rules in effect in the destinationTimeZone time zone.

For more information, please refer to this document:
https://learn.microsoft.com/en-us/dotnet/api/system.timezoneinfo.converttimefromutc?view=net-8.0&redirectedfrom=MSDN#System_TimeZoneInfo_ConvertTimeFromUtc_System_DateTime_System_TimeZoneInfo_

Hope this helps.

ADF_Coder 0 Reputation points

2024-07-17T10:31:00.4866667+00:00

Hi @NIKHILANETHIKUNTA ,

I am just asking about the default timezone, UTC, and not talking about any function (like convertfromUTC etc.).

I just wanted to know whether the by-default timezone (UTC) handled daylight saving.

If the source also has the same timezone

If the source has a different timezone other than UTC

Erland Sommarskog 106.2K Reputation points MVP

2024-07-17T11:50:30.3966667+00:00

I just wanted to know whether the by-default timezone (UTC) handled daylight saving.

As I said, UTC (Coordinated Universal Time) does not have any baggage with daylight savings time. UTC is not a time zone, rather this is the time, the time zones are defined from. To learn more about UTC, I recommend this Wikipedia article: https://en.wikipedia.org/wiki/Coordinated_Universal_Time
Sign in to comment

Share via

Convert UTC timezone to US

2 answers