How to correctly do time conversions
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
Operating system used: windows
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,160 NeuronEST 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.
-
your right, thank you!