I have a source, in this case oracle db, that is storing a date/time in GMT. Using a insert and update polling notification to publish a target system, also Oracle. The source table has the data in one record per hour, the target wants the data flatten out to one record per day with 24 columns.
The problem I am having as soon as I try to use any of the build date services it automatically changes to EST/EDT. In the flows that allow the timezone to be passed it returns the input time in the converted gmt time, ex. input 12/10/2008 02:00:00 GMT returns as 12/10/2008 21:00:00 EST. I need the time to stay in GMT.
Any way to set a session to run under a different time zone then what the jvm/server is running?