Numeric functions perform calculations.
Numeric functions accept an input number, which may come from a column in a table or from an expression that evaluates to a number.
A calculation is performed with this input and a number is returned.
An example of a numeric function is SQRT(), which returns the square root of the input number.
| Function | Description |
| ABS(x) | Returns the absolute value of x. |
| ACOS(x) | Returns the arccosine of x. |
| ASIN(x) | Returns the arcsine of x. |
| ATAN(x) | Returns the arctangent of x. |
| ATAN2(x, y) | Returns the arctangent of x and y. |
| BITAND(x, y) | Returns the result of performing a bitwise AND on x and y. |
| COS(x) | Returns the cosine of x, where x is an angle in radians. |
| COSH(x) | Returns the hyperbolic cosine of x. |
| CEIL(x) | Returns the smallest integer greater than or equal to x. |
| EXP(x) | Returns the result of the number e raised to the power x, where e is approximately 2.71828183. |
| FLOOR(x) | Returns the largest integer less than or equal to x. |
| LOG(x, y) | Returns the logarithm, base x, of y. |
| LN(x) | Returns the natural logarithm of x. |
| LN(2.71828183) = 1 | MOD(x, y) |
| Returns the remainder when x is divided by y. | POWER(x, y) |
| Returns the result of x raised to the power y. | ROUND(x [, y]) |
| Returns the result of rounding x an optional y decimal places. If y is omitted, x is rounded to zero decimal places. If y is negative, x is rounded to the left of the decimal point. | SIGN(x) |
| Returns -1 if x is negative, 1 if x is positive, or 0 if x is zero. | SIN(x) |
| Returns the sine of x. | SINH(x) |
| Returns the hyperbolic sine of x. | SQRT(x) |
| Returns the square root of x. | TAN(x) |
| Returns the tangent of x. | TAN(0) = 0 |
| TANH(x) | Returns the hyperbolic tangent of x. |
| TRUNC(x [, y]) | Returns the result of truncating x an optional y decimal places. If y is omitted, x is truncated to zero decimal places. If y is negative, x is truncated to the left of the decimal point. |