cancel
Showing results for 
Search instead for 
Did you mean: 

Datasphere - Convert UTC to EST considering DST(Daylight Savings) changes

prasanna_korada2
Explorer
0 Kudos

We would like to convert dates from UTC to EST in Datasphere modeling and found UTCTOLOCAL() function but it is not covering DST(Daylight Savings). Any suggestions on this?

Accepted Solutions (0)

Answers (1)

Answers (1)

Simon_Ye
Employee
Employee
0 Kudos

Hi,

You can use the UTCTOLOCAL() function, it has already considered the daylight savings as below:

In sample 1(May 1st,2023), UTC is 4 hours ahead EST; In sample 2(Feb 1,2023), it's 5 hours ahead EST.