CURRENT TIME ZONE

The CURRENT TIME ZONE special register specifies a value that contains the difference between UTC and local time as defined by the current server, if the SESSION TIME ZONE special register has not been set.

The local time difference for the current server is set by z/OS®, in the CLOCKxx PARMLIB member.

The data type is DECIMAL(6,0).

Start of change The difference between UTC and local time at the current server is represented by a time duration. A time duration is a decimal number in which the first two digits are the number of hours, the next two digits are the number of minutes, and the last two digits are the number of seconds. The number of hours is adjusted, if necessary, to fit in the range between -24 and 24 exclusive. End of change

Subtracting CURRENT TIME ZONE from a local time converts that local time to UTC.

CURRENT TIMEZONE can be specified as an alternative to CURRENT TIME ZONE.

Example: Select all the rows of the IN_TRAY table. Assume that the RECEIVED column is defined as TIMESTAMP WITHOUT TIME ZONE. Adjust the timestamp value in the RECEIVED column to UTC by subtracting the value of the CURRENT TIME ZONE special register.

  SELECT RECEIVED - CURRENT TIME ZONE, SOURCE, SUBJECT, NOTE_TEXT
		FROM IN_TRAY;