I see that the timezone present in the TN database tables (for activity log, bizdoc log etc) is in GMT.
It is not a problem if we use webMethods to query TN DB but when we query these tables directly to generate some reports, we get the data in the GMT timestamp.
Is there any way to modify this to the default server time zone?
We are currently on webMethods version 7.1.2 and the TN fix level is TNS_7.1.2_DB_Fix8.
I did see a couple of posts for issues similar to this, but there is no convincing answer.
Thanks in advance!!