INTERVAL HOUR TO SECOND - Advanced SQL Engine - Teradata Database

C Data Type Definition

typedef struct IntrvlHtoS
{
    SMALLINT hour;
    SMALLINT minute;
    DECIMAL4 seconds;
} IntrvlHtoS;

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 INTERVAL HOUR 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 HOUR TO SECOND type, see Teradata Vantage™ - Data Types and Literals, B035-1143.

Here is an example using INTERVAL HOUR TO SECOND in a UDF definition and C function declaration.

CREATE FUNCTION F1 (
 A INTERVAL HOUR(2) TO SECOND(2))
RETURNS INTERVAL HOUR TO SECOND
 ...;

void f1( IntrvlHtoS *a,
         IntrvlHtoS *result,
   ... )
{  ... }