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