15.10 - PERIOD(TIME WITH TIMEZONE) - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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.

 

Table 5: PERIOD(TIME WITH TIMEZONE) MEMBERS 

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.