IMPLICIT TIME ZONE field (IMPLICIT_TIMEZONE DECP value)
The IMPLICIT_TIMEZONE DECP value determines the implicit time zone that is to be used when a time zone is not provided. This parameter applies to Db2 table columns and routing parameters that are declared with TIMESTAMP WITH TIME ZONE data types.
| Acceptable values: | CURRENT, SESSION, -12:59 to +14:00 |
|---|---|
| Default: | CURRENT |
| Update: | not recommended1 |
| dsnhdecp: | IMPLICIT_TIMEZONE |
Note:
- Given the way that the implicit time zone is defined, a query might return different results before and after the IMPLICIT_TIMEZONE setting is changed. Or, if IMPLICIT_TIMEZONE is set to SESSION and an application changes the value of SESSION TIME ZONE through a SET SESSION TIME ZONE statement, a query might also return a different result. These situations apply to both static and dynamic applications.
- CURRENT
- Uses the setting of the CURRENT TIME ZONE special register as the implicit time zone. This is the default setting.
- SESSION
- Uses the setting of the SESSION TIME ZONE special register as the implicit time zone.
- -12:59 to +14:00
- Uses the value of the string as the implicit time zone. The format of the value is th:tm, where th is the time zone hour (-12 to +14), and tm is the time zone minute (00–59). This value is an offset of hours and minutes from the coordinated universal time (UTC). If the string does not indicate '+' or '-', a '+' value is assumed