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 shown in Table 5, are returned.
|
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.