This period datatype is similar to PERIOD(TIME), with the addition of a time zone.
Only character host variable formats are supported. Two TIME WITH TIMEZONE members, each with the format are returned, as shown in the following example:
Field | Displacement | Length | Description |
---|---|---|---|
Seconds | 0 | 4 | This integer represents the number of seconds as a scaled decimal. For example, 12.56 seconds is returned as 12560000. |
Hours | 4 | 1 | This integer represents the number of hours. |
Minutes | 5 | 1 | This integer represents the number of minutes. |
Timezone Hour | 6 | 1 | This integer represents the hours portion of the time zone displacement, and whether the displacement is + or -. A value of 16 represents 0 hours. A value less than 16 represents a negative time zone displacement for the specified hours. For example, if the value is 10, the time zone is displaced by -10 hours. If the value is greater than 16, it specifies a positive time zone displacement of (Time Zone Hour – 16) hours. For example, a value of 20 implies a +4 hour displacement. |
Timezone Minute | 7 | 1 | This integer represents the minutes portion of the time zone displacement. |
The total length of the output is 16 bytes.