> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Math functions

> Arithmetic, rounding, logarithmic, trigonometric and other numeric functions.

Arithmetic, rounding, logarithmic, trigonometric and other numeric functions.

| Function | Type | What it does |
| - | - | - |
| [`abs`](/query/sql/functions/math/abs) | Scalar | Returns the absolute value of a number. |
| [`acos`](/query/sql/functions/math/acos) | Scalar | Returns the inverse cosine of a number. |
| [`acosh`](/query/sql/functions/math/acosh) | Scalar | Returns the inverse hyperbolic cosine of a number. |
| [`asin`](/query/sql/functions/math/asin) | Scalar | Returns the inverse sine of a number. |
| [`asinh`](/query/sql/functions/math/asinh) | Scalar | Returns the inverse hyperbolic sine of a number. |
| [`atan`](/query/sql/functions/math/atan) | Scalar | Returns the inverse tangent of a number. |
| [`atan2`](/query/sql/functions/math/atan2) | Scalar | Returns the angle of the point (x, y) measured from the positive x axis. |
| [`atanh`](/query/sql/functions/math/atanh) | Scalar | Returns the inverse hyperbolic tangent of a number. |
| [`cbrt`](/query/sql/functions/math/cbrt) | Scalar | Returns the cube root of a number. |
| [`ceil`](/query/sql/functions/math/ceil) | Scalar | Rounds a number upward to an integral value. |
| [`ceiling`](/query/sql/functions/math/ceiling) | Scalar | Rounds a number upward to an integral value. |
| [`conv`](/query/sql/functions/math/conv) | Scalar | Converts an integer represented as text from one base to another. |
| [`cos`](/query/sql/functions/math/cos) | Scalar | Returns the cosine of an angle. |
| [`cosec`](/query/sql/functions/math/cosec) | Scalar | Returns the cosecant of an angle. |
| [`cosh`](/query/sql/functions/math/cosh) | Scalar | Returns the hyperbolic cosine of a number. |
| [`cot`](/query/sql/functions/math/cot) | Scalar | Returns the cotangent of an angle. |
| [`csc`](/query/sql/functions/math/csc) | Scalar | Returns the cosecant of an angle. |
| [`degrees`](/query/sql/functions/math/degrees) | Scalar | Converts radians to degrees. |
| [`exp`](/query/sql/functions/math/exp) | Scalar | Returns e raised to the power of a number. |
| [`factorial`](/query/sql/functions/math/factorial) | Scalar | Returns the factorial of an integer. |
| [`floor`](/query/sql/functions/math/floor) | Scalar | Rounds a number downward to an integral value. |
| [`hex`](/query/sql/functions/math/hex) | Scalar | Returns the hexadecimal representation of a number, string or binary value. |
| [`isnan`](/query/sql/functions/math/isnan) | Scalar | Tests whether a numeric value is NaN. |
| [`ln`](/query/sql/functions/math/ln) | Scalar | Returns the natural logarithm of a number. |
| [`log`](/query/sql/functions/math/log) | Scalar | Returns a logarithm in the specified base. |
| [`log10`](/query/sql/functions/math/log10) | Scalar | Returns the base-ten logarithm of a number. |
| [`log1p`](/query/sql/functions/math/log1p) | Scalar | Returns the natural logarithm of one plus the input. |
| [`log2`](/query/sql/functions/math/log2) | Scalar | Returns the base-two logarithm of a number. |
| [`mod`](/query/sql/functions/math/mod) | Scalar | Returns the remainder of division. |
| [`pi`](/query/sql/functions/math/pi) | Scalar | Returns a floating-point approximation of pi. |
| [`pmod`](/query/sql/functions/math/pmod) | Scalar | Returns the remainder adjusted using ((value % divisor) + divisor) % divisor. |
| [`pow`](/query/sql/functions/math/pow) | Scalar | Raises a base to an exponent. |
| [`power`](/query/sql/functions/math/power) | Scalar | Raises a base to an exponent. |
| [`radians`](/query/sql/functions/math/radians) | Scalar | Converts degrees to radians. |
| [`rand`](/query/sql/functions/math/rand) | Scalar | Returns a pseudorandom number whose type depends on the source dialect. |
| [`random`](/query/sql/functions/math/random) | Scalar | Returns a pseudorandom number whose type depends on the source dialect. |
| [`rint`](/query/sql/functions/math/rint) | Scalar | Rounds a number to the nearest integer, resolving halfway values to the even integer. |
| [`round`](/query/sql/functions/math/round) | Scalar | Rounds a number to the requested decimal position, resolving halfway values away from zero. |
| [`sec`](/query/sql/functions/math/sec) | Scalar | Returns the secant of an angle. |
| [`seq1`](/query/sql/functions/math/seq1) | Scalar | Produces a sequence of BIGINT values for each query, wrapping at the 8-bit boundary according to the sign option. |
| [`seq2`](/query/sql/functions/math/seq2) | Scalar | Produces a sequence of BIGINT values for each query, wrapping at the 16-bit boundary according to the sign option. |
| [`seq4`](/query/sql/functions/math/seq4) | Scalar | Produces a sequence of BIGINT values for each query, wrapping at the 32-bit boundary according to the sign option. |
| [`seq8`](/query/sql/functions/math/seq8) | Scalar | Produces a sequence of BIGINT values for each query, wrapping at the 64-bit boundary according to the sign option. |
| [`sign`](/query/sql/functions/math/sign) | Scalar | Returns the sign of a number or interval. |
| [`signum`](/query/sql/functions/math/signum) | Scalar | Returns the sign of a number or interval. |
| [`sin`](/query/sql/functions/math/sin) | Scalar | Returns the sine of an angle. |
| [`sinh`](/query/sql/functions/math/sinh) | Scalar | Returns the hyperbolic sine of a number. |
| [`sqrt`](/query/sql/functions/math/sqrt) | Scalar | Returns the square root of a number. |
| [`tan`](/query/sql/functions/math/tan) | Scalar | Returns the tangent of an angle. |
| [`tanh`](/query/sql/functions/math/tanh) | Scalar | Returns the hyperbolic tangent of a number. |
| [`try_divide`](/query/sql/functions/math/try_divide) | Scalar | Divides two numbers, returning NULL for a zero divisor. |
| [`try_multiply`](/query/sql/functions/math/try_multiply) | Scalar | Multiplies two numbers, returning NULL on integer or decimal overflow. |
| [`width_bucket`](/query/sql/functions/math/width_bucket) | Scalar | Returns the bucket containing a value within an equal-width range. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.