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.