C Data Type Definition
typedef struct ANSI_Time_WZone { DECIMAL4 seconds; BYTEINT hour; BYTEINT minute; BYTEINT zone_hour; BYTEINT zone_minutes; } ANSI_Time_WZone;
Usage
The seconds member is laid out as a DECIMAL(8,6) numeric field, which can represent up to two digits of whole seconds and six digits of fractional seconds.
The range of values defined for the SQL TIME WITH TIME ZONE type applies to the input arguments and return argument of a function. A value outside the valid range of values produces an error.
All TIME WITH TIME ZONE values passed to a UDF are in Universal Coordinated Time (UTC), and all TIME WITH TIME ZONE values that are returned from a UDF must be in UTC.
The TIME WITH TIME ZONE type has time zone fields, zone_hour and zone_minute, that have an internal form and an external form. When input arguments of this type are passed to a UDF, the values must be in internal form. Similarly, return arguments with this type must be in internal form.
To modify the time zone fields of the TIME WITH TIME ZONE type, use the following macros in the sqltypes_td.h file to convert between the internal and external representation of the time zone fields of ANSI_Time_Wzone and ANSI_TimeStamp_Wzone.
TIMEZONE_INTERNAL_TO_EXTERNAL(i, s, h, m)
TIMEZONE_EXTERNAL_TO_INTERNAL(s, h, m, i)
- i
- Pointer to either an ANSI_Time_Wzone or ANSI_TimeStamp_Wzone.
- s
- BYTEINT value to store the sign of i: 0 if h and m are negative and 1 if the they are positive.
- h
- BYTEINT value to store the hour offset of i.
- m
- BYTEINT value to store the minute offset of i.
The largest value for negative offsets is -12:59. The largest value for positive offsets is +14:00.
This representation results in two representations of UTC, that is +00:00 and -00:00. This mirrors the internal representation which uses both representations for display purposes.
For details on the TIME WITH TIME ZONE type, see Teradata Vantage™ - Data Types and Literals, B035-1143.
Here is an example of TIME WITH TIME ZONE in a UDF definition and C function declaration.
SQL Function Definition | Equivalent C Function Declaration |
---|---|
CREATE FUNCTION F1 ( A TIME WITH TIME ZONE) RETURNS TIME WITH TIME ZONE ...; |
void f1( ANSI_Time_WZone *a, ANSI_Time_WZone *result, ... ) { ... } |