Extracting time from datetime stamp
I am trying to extract the time from a timestamp in a redshift dataflow and cannot get the hours to extract correctly. My datetime field is in UTC and I need to convert the time zone to EST which is fine but when I try to get the time from the time stamp it returns the hours of the UTC time and not the converted timezone. Any help would be appreciated.
Screenshot below shows my first column stored in UTC, second column is the converted time zone and the following fields are my attempts to extract the time from the converted time zone value.
-----------------
Chris
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0 -
I am having a very similar problem. I put my documentation in a help ticket.
0 -
Have you tried splitting out the conversion and then extraction of the dates in different transforms? That might help pinpoint if it's a functional issue or if it's order of operations.
0 -
That seems really weird. I reproduced a few of your time stamps in a data set and then copied your code and it seems to have returned exactly what you were originally looking for.
So this would seem to suggest that there aren't any errors in the way you have written the formulas.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive