Numeric functions | Snowflake Documentation (original) (raw)
ReferenceFunction and stored procedure referenceNumeric
Numeric functions operate on numeric values and perform operations such as rounding and exponentiation.
| Sub-category | Function | Notes |
|---|---|---|
| Arithmetic | DIV0 | |
| DIV0NULL | ||
| Rounding and Truncation | ABS | |
| CEIL | ||
| FLOOR | ||
| MOD | ||
| ROUND | ||
| SIGN | ||
| TRUNCATE , TRUNC | ||
| Exponent and Root | CBRT | |
| EXP | ||
| FACTORIAL | ||
| POW, POWER | ||
| SQRT | ||
| SQUARE | ||
| Logarithmic | LN | |
| LOG | ||
| Trigonometric | ACOS | |
| ACOSH | ||
| ASIN | ||
| ASINH | ||
| ATAN | ||
| ATAN2 | ||
| ATANH | ||
| COS | ||
| COSH | ||
| COT | ||
| DEGREES | ||
| PI | ||
| RADIANS | ||
| SIN | ||
| SINH | ||
| TAN | ||
| TANH | ||
| Other | WIDTH_BUCKET |