DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  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)
                                                              • 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