I am testing some reports that run as a toad automation, scheduled on a server. Previously these were scheduled on my local machine via toad data point.
I have discovered that running the SQL on an oracle connection:
SELECT TO_CHAR (SYSDATE, 'd'), SYSDATE FROM DUAL
Returns one day of the week higher than I expected as its a database function.
E.g. If I run this toady I will receive: 4, 06/04/2022 hh:mm:ss
I expected to see 3, 06/04/2022 as I do from my local toad data point automation.
Any ideas on what the difference is between local toad data point and toad Intelligence Central on the server?