Default TImezone in the Dataflow

Question

Default TImezone in the Dataflow

Vaibhav 105

Hi Team,

Is there anyway to change the default timezone in the datafactory?

Currently, when I am creating a column(loadtime) with currentTimestamp() in derived column transformation in the dataflow, then I get the time in UTC. But, I want the default to be in CST.

I know that we can use conversion function to convert it to CST. However, checking if we can change the default timezone from UTC to CST.

2 answers

Your answer

Answer 1

Amira Bedhiafi 33,071 Volunteer Moderator

You can use a Derived Column where you use addHours to adjust the timestamp to CST which is UTC-6 hours, so you would subtract 6 hours from the UTC timestamp.


addHours(currentTimestamp(), -6)

toTimestamp(addHours(currentTimestamp(), -6), 'yyyy-MM-dd HH:mm:ss')toTimestamp(addHours(currentTimestamp(), -6), 'yyyy-MM-dd HH:mm:ss')

If you need to handle daylight saving time, you would need to implement conditional logic to adjust the offset based on the current date.


iif(

(month(currentTimestamp()) == 3 && day(currentTimestamp()) >= 8 && dayOfWeek(currentTimestamp()) == 1 && hour(currentTimestamp()) >= 2) ||

(month(currentTimestamp()) == 11 && day(currentTimestamp()) < 8 && dayOfWeek(currentTimestamp()) == 1 && hour(currentTimestamp()) < 2),

addHours(currentTimestamp(), -5),  // CDT

addHours(currentTimestamp(), -6)   // CST

)

Vaibhav 105 Reputation points

2024-05-28T20:00:32.4366667+00:00
@Amira Bedhiafi

Thanks for the response.

Apologies. There was a typo in my question. I meant CST instead of PST (Edited now)
Please suggest one below:

I know that we can use conversion function to convert from UTC to CST.
However, I just wanted to check if we can do it at global/default level in ADF so that currentTimestamp() will give me timings in CST rather than UTC.

Can we not use fromUTC(currentTimestamp(),'CST') to handle the Daylight savings?
Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-05-30T09:28:41.4633333+00:00
You cannot globally change the default timezone from UTC to CST for all timestamps and operations however, you can use fromUTC.

fromUTC(currentTimestamp(), 'Central Standard Time')

toTimestamp(fromUTC(currentTimestamp(), 'Central Standard Time'), 'yyyy-MM-dd HH:mm:ss')

This way, every time you use currentTimestamp(), it will be converted to CST using the fromUTC function, and you won’t need to manually handle daylight saving time adjustments.

Answer 2

Hi @Vaibhav

Thanks for the clarification.

As of now, there is no way to change the default timezone in Azure Data Factory. However, you can use the fromUTC function to convert the UTC timestamp to CST.

You can use the following expression in the Derived Column transformation to convert the timestamp to CST:

toTimestamp(fromUTC(currentTimestamp(), 'Central Standard Time'), 'yyyy-MM-dd HH:mm:ss')

This expression will convert the UTC timestamp to CST and handle the Daylight Saving Time automatically. Please note that you need to replace 'Central Standard Time' with the appropriate timezone name if you are not in the Central Time Zone.

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.

Share via

Default TImezone in the Dataflow

2 answers

Your answer