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 |
| 1Given 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 to 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
