Time Zone Construction

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 can get stored in the database.