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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive