Converting Time zone with day light saving

User2021 · 2021-11-23T18:59:52+00:00

There was an error rendering this rich post.

User2021

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.

Find more posts tagged with

Comments

GrantSmith

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

User2021

Thanks @GrantSmith you are always helpful!!

User2021

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

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

GrantSmith

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.

User2021

@GrantSmith It is not calculating daylight saving time.

User2021

I tagged you in another post where its same scenario

User2021

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