Converting Time zone with day light saving

User2021
User2021 Member
in Magic ETL

Hello,

I am trying to do a simple conversion of time zones of a datetime column from UTC to CST and EST. For some reason, I am getting error in this formula:

CONVERT_TZ(`DateTimecolumn`, 'utc', 'cst')

I also tried CDT instead of CST but getting error. I need something which works for time zone conversion as well as day light saving.

Comments

  • GrantSmith
    GrantSmith Coach
    edited November 2021

    Hi @User2021

    Instead of CST I'd recommend using the country/city name like this:

    CONVERT_TZ(`DateTimecolumn`, 'UTC', 'America/Chicago')

    You can use this in either a Beast Mode on a Card or a Formula Tile in a MagicETL 2.0 dataflow.


    Here's a list of timezone strings:

    https://timezonedb.com/time-zones

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • User2021
    User2021 Member

    Thanks @GrantSmith you are always helpful!!

  • User2021
    User2021 Member

    Hey @GrantSmith this country/city combination is not working. Any other idea?

    CONVERT_TZ(`ColumnName`, 'UTC', 'America/Chicago') AS UTC_TO_CST

  • GrantSmith
    GrantSmith Coach

    How is it not working? What are you getting? What are you expecting? Domo will convert your TIMESTAMP fields when a card is displayed to whatever time zone your instance is configured to.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • User2021
    User2021 Member

    @GrantSmith It is not calculating daylight saving time.

  • User2021
    User2021 Member

    I tagged you in another post where its same scenario

  • User2021
    User2021 Member

    Can anyone guide me how to solve daylight saving time problem in dataflow. I have already converted timezones as mentioned above by @GrantSmith

Categories