Resolution:

Abstract: 

= = = = 

How to get non-timezone datetime from a database.

Description:
========
By default, the date time retrieved from the datetime field is transferred in the following format: 2011-08-18T14:08:56.267-05:00

Environment:
=========
TIBCO ActiveMatrix BusinessWorks / All

Symptoms:
========
Obtaining the datetime with time zone from a database like the following while the datetime is not stored with time zone info: 2011-08-18T14:08:56.267-05:00

Cause:
=====
If the serverTimeZone of JDBC Call Procedure is left empty, by default it is set to the local time zone of the client box, with auto DST adjustment.

Resolution:
=======
If you want to get non-timezone data, you can specify ServerTimeZone to be "UTC" or "GMT". If there is nowhere to input the ServerTimeZone, you can reconfigure the JDBC Call Procedure activity or JDBC Query activity and the serverTimeZone will come out under  inputs element  on the Input tab.

How to obtain the non-timezone datetime from a database.