Handling Time Zone Conversions and Daylight Saving Time in Azure Fabric

[LucianoCarvajal]

I'm facing the following issue:

A process takes data with a column of date/time, which is in UTC. I need to transfer this data to another table and, in the process, generate a column with the LOCAL date/time, which varies between -3 or -4 in relation to UTC time, depending on the time of year (whether daylight saving time is active or not).

We are transferring data through a SQL SP, so I thought we could input a variable into the SP indicating the number of hours to adjust the UTC date/time to the local time zone.

For this, it's necessary to:

1. Identify whether the measurement (row) was taken with or without daylight saving time (by comparing the date to determine which period it falls into) and thus determine the hour difference.
2. Apply the corresponding hourly difference.
   
   

Can the Fabric environment be configured to a time zone with daylight saving time? This way, when using GETDATE(), we can obtain the local time.

In on-premise, the timedatectl --no-pager status command is used to obtain information about the local time zone, as well as the dates of the last and next daylight saving time changes. The result is saved in a .txt file which is then read to obtain the parameters and input them into a workflow.

However, I'm unsure if it's possible to obtain similar information in Fabric.

Any ideas on how to approach this issue?

[v-cboorla-msft]

Hi @LucianoCarvajal 

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.

Appreciate your patience.

Thanks

[v-cboorla-msft]

Hi @LucianoCarvajal 

Apologies for the delay in response from my end.

Please refer to the following document which might help you.

Document Link : convertFromUtc.

If the issue still persists, please do let us know. Glad to help.

I hope this information helps.

Thanks.

[v-cboorla-msft]

Hi @LucianoCarvajal 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @LucianoCarvajal 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

[LucianoCarvajal · Accepted solution]

Hello ! 

After trying several methods, we realized that the South Pacific Standard Time is aligned with the time and daylight saving changes in Chile. Therefore, at the pipeline level, we use the function to convert the time from UTC to this time zone, and within the stored procedures, we use AT TIME ZONE to convert UTC times to local times.