DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
For AI agents: documentation index at /llms.txt — fetch to discover all Snowflake documentation pages. Markdown version of this page: /en/sql-reference/functions-numeric.md
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • AI Functions
              1. AI_AGG
                • AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_COUNT_TOKENS
                    • AI_EMBED
                      • AI_EXTRACT
                      • AI_FILTER
                        • AI_MULTI_EMBED
                          • AI_PARSE_DOCUMENT
                            • AI_REDACT
                              • AI_SENTIMENT
                                • AI_SIMILARITY
                                  • AI_SUMMARIZE_AGG
                                    • AI_TRANSCRIBE
                                      • AI_TRANSLATE
                                        • FINETUNE (SNOWFLAKE.CORTEX)
                                        • SENTIMENT (SNOWFLAKE.CORTEX)
                                          • SUMMARIZE (SNOWFLAKE.CORTEX)
                                            • Helper functions
                                              1. AGENT_RUN (SNOWFLAKE.CORTEX)
                                                • DATA_AGENT_RUN (SNOWFLAKE.CORTEX)
                                                  • THREAD_MESSAGES (SNOWFLAKE.CORTEX)
                                                    • EXECUTE_AI_EVALUATION
                                                      • GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL)
                                                        • GET_AI_OBSERVABILITY_LOGS (SNOWFLAKE.LOCAL)
                                                          • GET_AI_OBSERVABILITY_EVENTS (SNOWFLAKE.LOCAL)
                                                            • GET_AI_RECORD_TRACE (SNOWFLAKE.LOCAL)
                                                              • SEARCH_PREVIEW (SNOWFLAKE.CORTEX)
                                                                • SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)
                                                                  • SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX)
                                                                • Bitwise expression
                                                                • Conditional expression
                                                                • Context
                                                                • Conversion
                                                                • Data generation
                                                                • Data metric
                                                                • Date & time
                                                                • Differential privacy
                                                                • Encryption
                                                                • File
                                                                • Geospatial
                                                                • Hash
                                                                • Metadata
                                                                • ML Model Monitors
                                                                • Notification
                                                                • Numeric
                                                                    1. Arithmetic
                                                                    2. 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
                                                                                                                                        • Organization users and organization user groups
                                                                                                                                        • Regular expressions
                                                                                                                                        • Semi-structured and structured data
                                                                                                                                        • Snowpark Container Services
                                                                                                                                        • String & binary
                                                                                                                                        • System
                                                                                                                                        • Table
                                                                                                                                        • Vector
                                                                                                                                        • Window
                                                                                                                                        • Stored procedures
                                                                                                                                    • Class reference
                                                                                                                                    • Scripting reference
                                                                                                                                    • General reference
                                                                                                                                    • API reference
                                                                                                                                      ReferenceFunction and stored procedure referenceNumeric

                                                                                                                                      Numeric functions¶

                                                                                                                                      Numeric functions operate on numeric values and perform operations such as rounding and exponentiation.

                                                                                                                                      Sub-categoryFunctionNotes
                                                                                                                                      ArithmeticDIV0
                                                                                                                                      DIV0NULL
                                                                                                                                      Rounding and TruncationABS
                                                                                                                                      CEIL
                                                                                                                                      FLOOR
                                                                                                                                      MOD
                                                                                                                                      ROUND
                                                                                                                                      SIGN
                                                                                                                                      TRUNCATE , TRUNC
                                                                                                                                      Exponent and RootCBRT
                                                                                                                                      EXP
                                                                                                                                      FACTORIAL
                                                                                                                                      POW, POWER
                                                                                                                                      SQRT
                                                                                                                                      SQUARE
                                                                                                                                      LogarithmicLN
                                                                                                                                      LOG
                                                                                                                                      TrigonometricACOS
                                                                                                                                      ACOSH
                                                                                                                                      ASIN
                                                                                                                                      ASINH
                                                                                                                                      ATAN
                                                                                                                                      ATAN2
                                                                                                                                      ATANH
                                                                                                                                      COS
                                                                                                                                      COSH
                                                                                                                                      COT
                                                                                                                                      DEGREES
                                                                                                                                      PI
                                                                                                                                      RADIANS
                                                                                                                                      SIN
                                                                                                                                      SINH
                                                                                                                                      TAN
                                                                                                                                      TANH
                                                                                                                                      OtherWIDTH_BUCKET

                                                                                                                                      Was this page helpful?

                                                                                                                                      Visit Snowflake
                                                                                                                                      Join the conversation
                                                                                                                                      Develop with Snowflake
                                                                                                                                      Share your feedback
                                                                                                                                      Read the latest on our blog
                                                                                                                                      Get your own certification
                                                                                                                                      Privacy NoticeSite TermsCookies Settings© 2026 Snowflake, Inc. All Rights Reserved.

                                                                                                                                      Alternative interfaces

                                                                                                                                      Snowflake Python APIsSnowflake REST APIsSnowflake CLI