why are my transactions dates coming in as shift dates?
I have a pretty simple query pulling from Oracle tables but it's transforming the dates when I run it through the workbench.
In SQL Developer, it returns the Actual Completion Date as 'DD-MON-YY HH24:MI:SS':
to_char(gbs.actual_cmplt_date,'DD-MON-YY HH24:MI:SS') "Actual Completion Date"
I've used this same syntax to generate just a date so that I can roll up the transaction details:
to_char(gbs.actual_cmplt_date, 'DD-MON-YY') "Trxn Date"
When I run the query in Developer and sort by Trx Date, it gives me all the actual_cmplt_date transactions between 00:00:00 and 23:59:59. i.e. 18-MAY-16 from 00:00:00 - 23:59:59
As soon as I run it in Domo and sort by Trx Date, it returns actual_cmplt_date transactions based on shift values, i.e. 17-MAY-16 from 19:00:00 - 23:59:59 and 18-MAY-16 from 00:00:00 to 18:59:59.
Schema values are DateTime for the Actual Completion Date transactions and date for the Trx Date.
Any thoughts why it would be doing this? Thanks!!
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board