The following table lists the available arithmetic functions, and a description of their purpose.
| Function | Description |
|---|---|
| CEILING | Returns the smallest integer value that is not less than the input argument. |
| FLOOR | Returns the largest integer equal to or less than the input argument. |
| GREATEST | Returns the largest value in the list of input arguments. |
| LEAST | Returns the least value among a list of numeric_values or string_values. |
| POWER | Returns base_value raised to the power of exponent_value. |
| SIGN | Returns the sign of numeric_value. |
| ROUND | Returns numeric_value rounded places_value places to the right or left of the decimal point. |
| TRUNC | Returns numeric_value truncated places_value places to the right or left of the decimal point. |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these arithmetic functions.