How is Timezone inherited from source then converted?

mcgeete
mcgeete Member
in Magic ETL

I have a dataset coming in from the Gong connector and some timestamps come in as text fields (scheduled, started). Our Domo timezone is set to Eastern. When I cast data type as timestamp, the times move up 3 hours.

Should I assume the Gong source data is Pacific (Gong is in SF) and Domo is inheriting the timezone properly? I don't see anything in the connector that indicates it is PT and I had thought Domo assumed times were UTC.

Tagged:

Best Answer

  • mcgeete
    mcgeete Member
    Answer ✓

    I think I've figured it out. All good now!

Answers

  • mcgeete
    mcgeete Member
    Answer ✓

    I think I've figured it out. All good now!

  • GrantSmith
    GrantSmith Coach
    edited June 2023

    When ingesting data Domo assumes UTC and when it gets to a visualization (in a card or on the dataset data tab) Domo will then convert your data to the Timezone company setting. Are there any other transformations happening on your data during processing or just converting it to a timestamp?

    Have you tried using the STR_TO_DATE function in a formula tile and specifying your own format string to convert it to a date and are you still getting the timezone offset issue?

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

Categories