Precedence of default time zone sources for ABL time date functions

The ABL TODAY, TIME, NOW, MTIME and TIMEZONE functions as well as database and temp-table fields with initial values of TODAY or NOW need a default time zone in order to be correctly resolved by the AVM. The following list describes the different time sources. The first item has the lowest precedence.

  • The default time zone of the operating system where the current session is running.
  • The time zone offset specified in the TIMEZONE attribute of the SESSION system handle. This attribute can be changed within the session.
  • The time zone of the server specified in the TIME-SOURCE attribute of the SESSION system handle. This attribute can be changed within the session.