The following aggregate functions are valid for Interval types.
For this function … | The result is … |
---|---|
AVG(arg) | the type of the argument. |
COUNT(arg) | INTEGER, if the mode is Teradata. |
DECIMAL(n,0), if the mode is ANSI, where:
|
|
MAX(arg) | the type of the argument, based on the comparison rules for DateTime types. |
MIN(arg) | |
SUM(arg) | the type of the argument. |
For more information about these functions, see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145.