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