> ## 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.

# Math Functions

## `abs`

*Supported Signatures*

```sql theme={null}
function abs $1($1) returns $1
	where $1 in (bigint, float64)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#abs)

## `acos`

*Supported Signatures*

```sql theme={null}
function acos $1($1) returns double
	where $1 in (double, bigint)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#acos)

## `acosh`

*Supported Signatures*

```sql theme={null}
function acosh $1($1) returns double
	where $1 in (double, bigint)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#acosh)

## `asin`

*Supported Signatures*

```sql theme={null}
function asin $1($1) returns double
	where $1 in (double, bigint)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#asin)

## `asinh`

*Supported Signatures*

```sql theme={null}
function asinh $1($1) returns double
	where $1 in (double, bigint)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#asinh)

## `atan`

*Supported Signatures*

```sql theme={null}
function atan $1($1) returns double
	where $1 in (double, bigint)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#atan)

## `atan2`

*Supported Signatures*

```sql theme={null}
function atan2 $1, $2($1, $2) returns double
	where $1 in (bigint, double)
	and $2 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#atan2)

## `atanh`

*Supported Signatures*

```sql theme={null}
function atanh $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#atanh)

## `cbrt`

*Supported Signatures*

```sql theme={null}
function cbrt $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#cbrt)

## `ceil`

*Supported Signatures*

```sql theme={null}
function ceil(bigint) returns double
function ceil $1($1) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ceil)

## `ceiling`

*Supported Signatures*

```sql theme={null}
function ceiling(bigint) returns double
function ceiling $1($1) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ceiling)

## `cos`

*Supported Signatures*

```sql theme={null}
function cos $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#cos)

## `cosh`

*Supported Signatures*

```sql theme={null}
function cosh $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#cosh)

## `cot`

*Supported Signatures*

```sql theme={null}
function cot $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#cot)

## `coth`

*Supported Signatures*

```sql theme={null}
function coth $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#coth)

## `csc`

*Supported Signatures*

```sql theme={null}
function csc $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#csc)

## `csch`

*Supported Signatures*

```sql theme={null}
function csch $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#csch)

## `div`

*Supported Signatures*

```sql theme={null}
function div $1($1, $1) returns $1
	where $1 in (bigint)
function div(bigint, decimal(p,s)) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(decimal(p,s), bigint) returns decimal(p,s)
function div(bigint, decimal(p,s)) returns decimal(p,s)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#div)

## `exp`

*Supported Signatures*

```sql theme={null}
function exp(bigint) returns double
function exp $1($1) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#exp)

## `floor`

*Supported Signatures*

```sql theme={null}
function floor $1($1) returns $1
	where $1 in (double)
function floor(bigint) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#floor)

## `greatest`

*Supported Signatures*

```sql theme={null}
function greatest $1($1, ...) returns $1
	where $1 in (bigint, double, timestamp, date, time)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#greatest)

## `ieee_divide`

*Supported Signatures*

```sql theme={null}
function ieee_divide $1, $2($1, $2) returns double
	where $1 in (bigint, double)
	and $2 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ieee_divide)

## `is_inf`

*Supported Signatures*

```sql theme={null}
function is_inf $1($1) returns bool
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#is_inf)

## `is_nan`

*Supported Signatures*

```sql theme={null}
function is_nan $1($1) returns bool
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#is_nan)

## `least`

*Supported Signatures*

```sql theme={null}
function least $1($1, ...) returns $1
	where $1 in (bigint, double, timestamp, date, time)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#least)

## `ln`

*Supported Signatures*

```sql theme={null}
function ln(bigint) returns double
function ln $1($1) returns double
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#ln)

## `log`

*Supported Signatures*

```sql theme={null}
function log(bigint) returns double
function log $1($1) returns double
	where $1 in (double)
function log $1($1, $1) returns $1
	where $1 in (double)
function log(bigint, bigint) returns double
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(decimal(p,s), bigint) returns decimal(p,s)
function log(bigint, decimal(p,s)) returns decimal(p,s)
function log(double, bigint) returns double
function log(bigint, double) returns double
function log(decimal(p,s), double) returns double
function log(double, decimal(p,s)) returns double
function log(double, decimal(p,s)) returns double
function log(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#log)

## `log10`

*Supported Signatures*

```sql theme={null}
function log10(bigint) returns double
function log10 $1($1) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#log10)

## `mod`

*Supported Signatures*

```sql theme={null}
function mod $1($1, $1) returns $1
	where $1 in (bigint)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(decimal(p,s), bigint) returns decimal(p,s)
function mod(bigint, decimal(p,s)) returns decimal(p,s)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#mod)

## `pow`

*Supported Signatures*

```sql theme={null}
function pow $1($1, $1) returns $1
	where $1 in (double)
function pow(bigint, bigint) returns double
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(decimal(p,s), bigint) returns decimal(p,s)
function pow(bigint, decimal(p,s)) returns decimal(p,s)
function pow(double, bigint) returns double
function pow(bigint, double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
function pow(double, decimal(p,s)) returns double
function pow(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#pow)

## `power`

*Supported Signatures*

```sql theme={null}
function power $1($1, $1) returns $1
	where $1 in (double)
function power(bigint, bigint) returns double
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(decimal(p,s), bigint) returns decimal(p,s)
function power(bigint, decimal(p,s)) returns decimal(p,s)
function power(double, bigint) returns double
function power(bigint, double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
function power(double, decimal(p,s)) returns double
function power(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#power)

## `rand`

*Supported Signatures*

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

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#rand)

## `range_bucket`

*Supported Signatures*

```sql theme={null}
function range_bucket($1, array<$1>) returns int64
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#range_bucket)

## `round`

*Supported Signatures*

```sql theme={null}
function round(bigint) returns double
function round $1($1) returns $1
	where $1 in (double)
function round(bigint, bigint) returns double
function round $1($1, bigint) returns $1
	where $1 in (double)
function round(bigint, bigint, rounding_mode string) returns double
	where rounding_mode in (round_half_even, round_half_away_from_zero)
function round $1($1, bigint, rounding_mode string) returns $1
	where rounding_mode in (round_half_even, round_half_away_from_zero)
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#round)

## `safe_add`

*Supported Signatures*

```sql theme={null}
function safe_add $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(decimal(p,s), bigint) returns decimal(p,s)
function safe_add(bigint, decimal(p,s)) returns decimal(p,s)
function safe_add(double, bigint) returns double
function safe_add(bigint, double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
function safe_add(double, decimal(p,s)) returns double
function safe_add(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_add)

## `safe_divide`

*Supported Signatures*

```sql theme={null}
function safe_divide $1($1, $1) returns double
	where $1 in (bigint, double)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(decimal(p,s), bigint) returns decimal(p,s)
function safe_divide(bigint, decimal(p,s)) returns decimal(p,s)
function safe_divide(double, bigint) returns double
function safe_divide(bigint, double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
function safe_divide(double, decimal(p,s)) returns double
function safe_divide(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_divide)

## `safe_multiply`

*Supported Signatures*

```sql theme={null}
function safe_multiply $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(decimal(p,s), bigint) returns decimal(p,s)
function safe_multiply(bigint, decimal(p,s)) returns decimal(p,s)
function safe_multiply(double, bigint) returns double
function safe_multiply(bigint, double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
function safe_multiply(double, decimal(p,s)) returns double
function safe_multiply(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_multiply)

## `safe_negate`

*Supported Signatures*

```sql theme={null}
function safe_negate $1($1) returns $1
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_negate)

## `safe_subtract`

*Supported Signatures*

```sql theme={null}
function safe_subtract $1($1, $1) returns $1
	where $1 in (bigint, double)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(decimal(p,s), bigint) returns decimal(p,s)
function safe_subtract(bigint, decimal(p,s)) returns decimal(p,s)
function safe_subtract(double, bigint) returns double
function safe_subtract(bigint, double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
function safe_subtract(double, decimal(p,s)) returns double
function safe_subtract(decimal(p,s), double) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#safe_subtract)

## `sec`

*Supported Signatures*

```sql theme={null}
function sec $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sec)

## `sech`

*Supported Signatures*

```sql theme={null}
function sech $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sech)

## `sign`

*Supported Signatures*

```sql theme={null}
function sign $1($1) returns $1
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sign)

## `sin`

*Supported Signatures*

```sql theme={null}
function sin $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sin)

## `sinh`

*Supported Signatures*

```sql theme={null}
function sinh $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sinh)

## `sqrt`

*Supported Signatures*

```sql theme={null}
function sqrt(bigint) returns double
function sqrt $1($1) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#sqrt)

## `tan`

*Supported Signatures*

```sql theme={null}
function tan $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#tan)

## `tanh`

*Supported Signatures*

```sql theme={null}
function tanh $1($1) returns double
	where $1 in (bigint, double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#tanh)

## `trunc`

*Supported Signatures*

```sql theme={null}
function trunc(bigint) returns double
function trunc $1($1) returns $1
	where $1 in (double)
function trunc(bigint, bigint) returns double
function trunc $1($1, bigint) returns $1
	where $1 in (double)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#trunc)