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

# Numeric functions

> Snowflake numeric functions supported in Snowflake compatibility mode.

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

Snowflake [numeric functions](https://docs.snowflake.com/en/sql-reference/functions-numeric) in [Snowflake compatibility mode](/reference-sql/snowflake/overview).

| Function | Support | Notes |
| :- | :- | :- |
| `ABS` | Supported | |
| `ACOS` | Supported | |
| `ASIN` | Supported | |
| `ATAN2` | Supported | |
| `ATAN` | Supported | |
| `CBRT` | Supported | |
| `CEIL` | Supported | |
| `COS` | Supported | |
| `COT` | Supported | |
| `DEGREES` | Supported | |
| `EXP` | Supported | |
| `FLOOR` | Supported | |
| `LN` | Supported | |
| `LOG` | Supported | |
| `MOD` | Supported | |
| `PI` | Supported | |
| `POWER` | Supported | |
| `POW` | Supported | |
| `RADIANS` | Supported | |
| `ROUND` | With limitations | Rounds half to even; Snowflake rounds half away from zero, so results differ on exact `.5` ties (`ROUND(2.5)` returns `2`, not `3`). |
| `SIGN` | Supported | |
| `SIN` | Supported | |
| `SQRT` | Supported | |
| `SQUARE` | Supported | |
| `TAN` | Supported | |
| `TRUNCATE` | Supported | |
| `TRUNC` | Supported | |
| [`SINH`](https://docs.snowflake.com/en/sql-reference/functions/sinh) | Supported | Rejects an overflowing argument, where Snowflake answers infinity. |
| [`COSH`](https://docs.snowflake.com/en/sql-reference/functions/cosh) | Supported | Rejects an overflowing argument, where Snowflake answers infinity. |
| [`TANH`](https://docs.snowflake.com/en/sql-reference/functions/tanh) | Supported | |
| [`ASINH`](https://docs.snowflake.com/en/sql-reference/functions/asinh) | Supported | |
| [`ACOSH`](https://docs.snowflake.com/en/sql-reference/functions/acosh) | Supported | |
| [`ATANH`](https://docs.snowflake.com/en/sql-reference/functions/atanh) | Supported | |
| `DIV0`, `DIV0NULL`, `FACTORIAL`, `NEGATE`, `WIDTH_BUCKET` | Not supported | |

## Limitations

`ROUND`, `CEIL`, `FLOOR`, `TRUNC` and `TRUNCATE` return a floating-point value where Snowflake returns a fixed-point `NUMBER`, and `AVG` does the same. The value agrees; the declared type does not, which matters where a client reads the column type or where the difference between decimal and binary floating point is significant. The result type follows the argument's type in Snowflake, which is not known at translation time here.


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