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

# Numeric Functions

## `acos`

Compute the arccosine of the input expression (returned as radians).
*Supported Signatures*

```sql theme={null}
function acos(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/acos)

## `acosh`

Compute the inverse hyperbolic cosine of the input expression.
*Supported Signatures*

```sql theme={null}
function acosh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/acosh)

## `asin`

Compute the arcsine of the input expression (returned as radians).
*Supported Signatures*

```sql theme={null}
function asin(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/asin)

## `asinh`

Compute the inverse hyperbolic sine of the input expression.
*Supported Signatures*

```sql theme={null}
function asinh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/asinh)

## `atan`

Compute the arctangent of the input expression (returned as radians).
*Supported Signatures*

```sql theme={null}
function atan(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/atan)

## `atan2`

Compute the angle (in radians) between the x-axis and point (x, y).
*Supported Signatures*

```sql theme={null}
function atan2(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/atan2)

## `atanh`

Compute the inverse hyperbolic tangent of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function atanh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/atanh)

## `cbrt`

Compute the cubic root of the input expression.
*Supported Signatures*

```sql theme={null}
function cbrt(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/cbrt)

## `ceil`

round to the nearest integer not smaller than input
*Supported Signatures*

```sql theme={null}
function ceil(decimal(38, 0)) returns decimal(38, 0)
function ceil(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function ceil(double) returns double
function ceil(double, decimal(38, 0)) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/ceil)

## `cos`

Compute the cosine of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function cos(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/cos)

## `cosh`

Compute the hyperbolic cosine of the input expression.
*Supported Signatures*

```sql theme={null}
function cosh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/cosh)

## `cot`

Compute the cotangent of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function cot(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/cot)

## `degrees`

convert r (radians) to degrees.
*Supported Signatures*

```sql theme={null}
function degrees(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/degrees)

## `div0`

Divides two numbers; returns 0 if divisor is 0
*Supported Signatures*

```sql theme={null}
function div0(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function div0(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/div0)

## `div0null`

Divides two numbers; returns 0 if divisor is 0 or null
*Supported Signatures*

```sql theme={null}
function div0null(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function div0null(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/div0null)

## `exp`

returns e raised to the x'th power
*Supported Signatures*

```sql theme={null}
function exp(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/exp)

## `factorial`

Factorial of f
*Supported Signatures*

```sql theme={null}
function factorial(decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/factorial)

## `floor`

round to the nearest integer not greater than input
*Supported Signatures*

```sql theme={null}
function floor(decimal(38, 0)) returns decimal(38, 0)
function floor(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function floor(double) returns double
function floor(double, decimal(38,0)) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/floor)

## `ln`

returns the natural logarithm of a
*Supported Signatures*

```sql theme={null}
function ln(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/ln)

## `log`

returns the logarithm base b of a
*Supported Signatures*

```sql theme={null}
function log(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/log)

## `mod`

Computes modulo of two numbers
*Supported Signatures*

```sql theme={null}
function mod(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function mod(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/mod)

## `pi`

Returns the constant pi.
*Supported Signatures*

```sql theme={null}
function pi() returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/pi)

## `pow`

returns x raised to the y'th power
*Supported Signatures*

```sql theme={null}
function pow(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/pow)

## `power`

returns x raised to the y'th power
*Supported Signatures*

```sql theme={null}
function power(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/power)

## `radians`

convert d (degrees) to radians.
*Supported Signatures*

```sql theme={null}
function radians(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/radians)

## `round`

round to the nearest integer, with .5 rounded away from 0
*Supported Signatures*

```sql theme={null}
function round(double) returns double
function round(double, double) returns double
function round(double, double, varchar) returns double
function round(decimal(38, 0)) returns decimal(38, 0)
function round(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function round(decimal(38, 0), decimal(38, 0), varchar) returns decimal(38, 0)
function round() returns bigint
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/round)

## `sign`

returns sign of x
*Supported Signatures*

```sql theme={null}
function sign(decimal(38, 0)) returns decimal(38, 0)
function sign(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sign)

## `sin`

Compute the sine of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function sin(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sin)

## `sinh`

Compute the hyperbolic sine of the input expression.
*Supported Signatures*

```sql theme={null}
function sinh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sinh)

## `sqrt`

Compute the square root of the input expression.
*Supported Signatures*

```sql theme={null}
function sqrt(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sqrt)

## `square`

Compute the square of the input expression.
*Supported Signatures*

```sql theme={null}
function square(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/square)

## `tan`

Compute the tangent of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function tan(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/tan)

## `tanh`

Compute the hyperbolic tangent of the input expression (as radians).
*Supported Signatures*

```sql theme={null}
function tanh(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/tanh)

## `truncate`

truncate the fractional or date part
*Supported Signatures*

```sql theme={null}
function truncate(decimal(38, 0)) returns decimal(38, 0)
function truncate(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function truncate(double) returns double
function truncate(double, double) returns double
function truncate(date, varchar) returns date
function truncate(time, varchar) returns time
function truncate(timestamp, varchar) returns timestamp
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/truncate)

## `width_bucket`

returns the bucket a value falls into in an equiwidth histogram
*Supported Signatures*

```sql theme={null}
function width_bucket(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function width_bucket(double, double, double, decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/width_bucket)