UTC to Eastern time zone adjustment
My question for the Domo Brillance Bar when arriving at the detroit user group:
We have a connection from 5/9s system to Domo with a timestamp column in the dataset. We created cards with this dataset and realized that the data was not reporting in the correct time zone. We added this dataset as in input in a dataflow and added a transform to convert the timestamp field to a date/time instead of text.
This is the code we added in our dataflow:
DATE_FORMAT(str_to_date(`TIMESTAMP`, '%a, %e %b %Y %T'),'%m/%d/%Y %k:%i:%s') AS ConvertedTimeStamp
Then we used the new field ConvertedTimeStamp in our cards to report the correct time zone for the calls that come in to our call center.
Any questions please feel free to reach out to me.
Thank you
Kevin
Best Answer
Answers
-
Hi! I use ETL for my dataflows, not SQL. Is there a way to do this conversion inside an ETL dataflow? I have the Scripting beta that allows me to include Python or R, but I don't know what to do next. Anyone willing to lend a hand?
Field is EVENT_DATE_TIME and I need to make 6/21/2016 3:30:00 PM change to 7:30 PM, for example.
Thanks!
Broadway + Data0 -
The only way in found to do in ETL is to add or subtract hours, not ideal unfortunately.
- Convert Date/Time to decimal
- Add or subtract the hours you need (1 = 1 milisecond)
- Convert back to Date and Time
3
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive