This section contains recommendations related to configuration of database connections and usage.

Time Zone Settings

When processing data relating to a different time zone from the local time zone, you may want to use the original time zone for the time information stored.

To store a date object with the attached time zone in the database, set the Execution Context and Platform property mz.use.date.timezone to true. This will instruct to This will instruct the system to use the attached time zone when SQL input originates from a date object.

In most cases, it is sufficient to set the property in the pico configuration of the EC/ECSA. However, in case of audit processing, you must also set the property in the pico configuration of the Platform.

...