Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

How to correctly do time conversions

abalo006
Level 3
How to correctly do time conversions

TIME.PNG

I have a column that has been parsed and is in UTC, when I try to format the date to be in eastern / New York time I get a new column that is -5 hours, but isn't the current the current difference -4 hours? I'm sure this has something to do with daylight savings time vs normal time, but I just want to ensure that my formula remains working even when times are changed by an hour due to daylight savings.

does anybody know how I can get the correct time difference from UTC to ET?

 

I've attached the steps I'm currently using below

step1.PNGstep2.PNG


Operating system used: windows

0 Kudos
2 Replies

EST is 5hs from UTC on autumn/winter:

https://en.wikipedia.org/wiki/Eastern_Time_Zone

Try with a summer date and you will see 4hs. START_TIME is not a proper parsed Date, it's a string.

abalo006
Level 3
Author

your right, thank you!

0 Kudos