SET SESSION TIME ZONE
The SET SESSION TIME ZONE statement assigns a value to the SESSION TIME ZONE special register.
Invocation
This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.
Authorization
None required.
Syntax
.-SESSION-. .-=-. >>-SET--+---------+-- TIME ZONE--+---+--+-string-constant-+---->< '-variable--------'
Description
- string-constant
- Identifies a time zone with a value of the form '±th:tm' , where th represents the time zone hour between -12 and +14, and tm represents the time zone minutes between 0 and 59, with values ranging from -12:59 to +14:00.
- variable
- Specifies a variable that contains a time zone. The variable must be a CHAR or VARCHAR variable that is not followed by an indicator variable. The variable must not be the null value. The value must be left justified and be of the form '±th:tm' , where th represents the time zone hour between -12 and +14, and tm represents the time zone minutes between 0 and 59, with values ranging from -12:59 to +14:00.
Notes
- Impact on other special registers:
- Setting the SESSION TIME ZONE special register does not affect the CURRENT TIMEZONE special register.
- Syntax alternatives:
- SESSIONTIMEZONE, SESSION TIMEZONE, and TIMEZONE can be specified as an alternative to SESSION TIME ZONE or TIME ZONE.
Example
Set
the SESSION TIME ZONE as -8:00:
SET SESSION TIME ZONE = '-8:00';