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

# Math functions

> BigQuery mathematical functions supported in BigQuery compatibility mode.

<span className="feature-tag">Preview</span>

BigQuery [mathematical functions](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions) in [BigQuery compatibility mode](/reference-sql/bigquery/overview).

| Function | Support | Notes |
| :- | :- | :- |
| [`ABS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#abs) | Supported | |
| [`SIGN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sign) | Supported | |
| [`CEIL`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil) | Supported | |
| [`CEILING`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceiling) | Supported | |
| [`FLOOR`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#floor) | Supported | |
| [`ROUND`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round) | With limitations | Rounds half to even; BigQuery rounds half away from zero, so results differ on exact `.5` ties (`ROUND(2.5)` returns `2`, not `3`). |
| [`TRUNC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc) | Supported | |
| [`MOD`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod) | Supported | |
| [`DIV`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div) | Supported | Integer division. |
| [`POW`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow) | Supported | |
| [`POWER`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power) | Supported | |
| [`SQRT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sqrt) | Supported | |
| [`CBRT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cbrt) | Supported | |
| [`EXP`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#exp) | Supported | |
| [`LN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ln) | Supported | |
| [`LOG`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log) | Supported | |
| [`LOG10`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log10) | Supported | |
| [`GREATEST`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#greatest) | Supported | |
| [`LEAST`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#least) | Supported | |
| [`RAND`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#rand) | Supported | |
| [`SIN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sin) | Supported | |
| [`COS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cos) | Supported | |
| [`TAN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tan) | Supported | |
| [`COT`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cot) | Supported | |
| [`ASIN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asin) | Supported | |
| [`ACOS`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acos) | Supported | |
| [`ATAN`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan) | Supported | |
| [`ATAN2`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan2) | Supported | |
| [`CSC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csc) | Supported | Reciprocal of sine. |
| [`SEC`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sec) | Supported | Reciprocal of cosine. |
| [`SAFE_DIVIDE`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide) | Supported | Returns `NULL` when the divisor is 0. |
| [`SINH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sinh) | Supported | |
| [`COSH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cosh) | Supported | |
| [`TANH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tanh) | Supported | |
| [`ASINH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asinh) | Supported | |
| [`ACOSH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acosh) | Supported | |
| [`ATANH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atanh) | Supported | |
| [`COTH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#coth) | Supported | |
| [`CSCH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csch) | Supported | |
| [`SECH`](https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sech) | Supported | |
| `SAFE_ADD`, `SAFE_MULTIPLY`, `SAFE_NEGATE`, `SAFE_SUBTRACT` | Not supported | |
| `IS_INF`, `IS_NAN`, `RANGE_BUCKET`, `COSINE_DISTANCE`, `EUCLIDEAN_DISTANCE` | Not supported | |


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