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