C Data Type Definition
typedef struct IntrvlDtoS { DECIMAL4 seconds; SMALLINT day; SMALLINT hour; SMALLINT minute; } IntrvlDtoS;
Usage
The first 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. For details, see Teradata Vantage™ - Data Types and Literals, B035-1143.
The range of values defined for the SQL INTERVAL DAY TO SECOND type applies to the input arguments and return argument of a function. A value outside the valid range of values produces an error. For details on the INTERVAL DAY TO SECOND type, see Teradata Vantage™ - Data Types and Literals, B035-1143.
Here is an example using INTERVAL DAY TO SECOND in a UDF definition and IntrvlDtoS in a C function declaration.
SQL Function Definition | Equivalent C Function Declaration |
---|---|
CREATE FUNCTION F1 ( A INTERVAL DAY(4) TO SECOND(3)) RETURNS INTERVAL DAY TO SECOND ...; |
void f1( IntrvlDtoS *a, IntrvlDtoS *result, ... ) { ... } |