Use SESSION:TIMEZONE (-useSessionTZ)

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	—

0 indicates SESSION:TIMEZONE is not used with assignments, and 1 indicates SESSION:TIMEZONE is used. The default value is 1.

For releases 11.6.0 and earlier, the SESSION:TIMEZONE attribute only affected the MTIME, NOW, TIME, TIMEZONE, and TODAY functions. As of version 11.7, the AVM 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 on direct assignment operations and how they're affected by SESSION:TIMEZONE, see the ASSIGN statement (notes section) and SESSION:TIMEZONE entries in OpenEdge Development: ABL Reference.