Use SESSION:TIMEZONE (-useSessionTZ) specifies whether or not the SESSION:TIMEZONE attribute is applied to results of direct assignments between DATE, DATETIME, and DATETIME-TZ data types.

Operating system and syntax UNIX / Windows -useSessionTZ n
Use with Maximum value Minimum value Single-user default Multi-user default
Client Session — — 1 —
n
0 indicates SESSION:TIMEZONE is not used with assignments, and 1 indicates SESSION:TIMEZONE is used. The default value is 1.

For earlier OpenEdge releases, the SESSION:TIMEZONE attribute affected only the MTIME, NOW, TIME, TIMEZONE, and TODAY functions. However, the AVM now uses the value of SESSION:TIMEZONE, when set, to calculate the results of:

  • Functions DATETIME-TZ, MTIME, NOW, TIME, TIMEZONE, and TODAY
  • Direct assignment operations between DATE, DATETIME, and DATETIME-TZ data types.
You can revert to the behavior of earlier releases by specifying the -useSessionTZ 0 parameter.
Note: For more information about direct assignment operations and how they're affected by SESSION:TIMEZONE, see the ASSIGN statement (notes section) and TIMEZONE attribute entries in the ABL Reference.