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!!