Time Zone Construction TIBCO ActiveMatrix BusinessWorks constructs any date and time data returned from the database with the time zone specified in the ServerTimeZone input element. Constructed DateTime data is in a UTC-normalized form, and daylight savings adjustments are also automatically applied. If an invalid time zone name is specified, an InvalidTimeZoneException is thrown. If no value is specified in this input item, it is assumed that the database server is in the same time zone as the local machine. All activities that retrieve and modify data to be later updated in a database should specify the same time zone for the database server or potentially incorrect values will be stored in the database. Examples Date in Database serverTimeZone Constructed DateTime Dec/5/1972 no value 1972-12-05T00:00:00-08:00 Jun/2/2003 no value 2003-06-02T00:00:00-07:00 Dec/5/1972 America/Los_Angeles 1972-12-05T00:00:00-08:00 Jun/2/2003 America/Los_Angeles 2003-06-02T00:00:00-07:00 Dec/5/1972 EST 1972-12-05T00:00:00-05:00 Jun/2/2003 EST 2003-06-02T00:00:00-04:00
