Posted 26 September 2017, 10:09 am ESTHello I'm trying to set up a session timezone before running the query for a report. As an example what I would need is for the application to run this command:
ALTER SESSION SET TIME_ZONE = 'US/Eastern'
Followed by the query the report uses. This needs to all be in the same session without having to establish a new connection so that this timezone applies to the query. This is needed so that fields of type timestamp are interpreted according to the timezone we would be reporting for so that the return data is shown in that rather than my own.