Beast Mode - UTC to Mountain Time

user03543
user03543 Member
in Magic ETL

Hey!

 

I need help with doing a beast mode calculation. I have 'Date SO Created" and it has UTC time zone, which I need to convert to Mountain Time. 

 

The data is shown as "6/4/2018 2:41:00 AM"

 

I heard about CONVERT_TZ and I have tried plugging it in myself, but nothing is validated.

 

Thank you!

Best Answer

  • user03543
    user03543 Member
    Answer ✓

    Nevermind, I figured how to add time to my data. Thanks!

     

    Please close

Answers

  • ST_-Superman-_
    ST_-Superman-_ Coach

    Have you tried using CONVERT_TZ as part of a dataflow rather than in a beastmode?  I don't think that funciton is available in beast mode.


    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
  • user03543
    user03543 Member

    My BI specialist does most of the backend work and he has a few projects to work on.

     

    There is a 6 hours difference between the UTC and Mountain Time.. Could I just add 6 hours to the data. If so, how?

     

    THanks

  • user03543
    user03543 Member
    Answer ✓

    Nevermind, I figured how to add time to my data. Thanks!

     

    Please close

Categories