> ## Documentation Index
> Fetch the complete documentation index at: https://firebolt-aggregate-helm-docs-pr-97.mintlify.site/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        |                                                                                                                                      |
| `ASINH`, `ATANH`, `COSH`, `DIV0`, `DIV0NULL`, `FACTORIAL`, `NEGATE`, `SINH`, `TANH`, `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.