Skip to content

    • Magic ETL

    Magic ETL

    Converting Time zone with day light saving

    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.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Coach
      edited November 2021

      Hi @User2021

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

      1. 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!**
    • Member

      Thanks @GrantSmith you are always helpful!!

    • Member

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

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

    • 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!**
    • Member

      @GrantSmith It is not calculating daylight saving time.

    • Member

      I tagged you in another post where its same scenario

    • Member

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories