Timezone Conversion in ETL

Figauro
Figauro 🟑
in Ideas Exchange

Since most datasets are brought in at UTC time, there should be an option in the ETL to convert date/time timezones so that I can then have a proper date/time to date conversion to throw in a group by. Currently, the date/time to date will result in a UTC date which isn't helpful at all. I could add hours to the date/time, but once daylight savings hits I'd have to change all the flows and it wouldn't be correct for all date/times.Β 

Tagged:
10
Up
10 votes

Β· Last Updated

Comments

  • AndrewMeier
    AndrewMeier 🟑

    We have major Timezone issues like this as well. Getting this fixed would be a HUGE plus for our Organization.

  • Sweep_The_Leg
    Sweep_The_Leg 🟑

    Always struggling with time zones as well. Even a static date field from a spreadsheet gets converted.Β 

This discussion has been closed.

Categories