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. Scalar functions
                1. AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_COUNT_TOKENS
                    • AI_EMBED
                      • AI_EXTRACT
                      • AI_FILTER
                        • AI_PARSE_DOCUMENT
                          • AI_REDACT
                            • AI_SENTIMENT
                              • AI_SIMILARITY
                                • AI_TRANSCRIBE
                                  • AI_TRANSLATE
                                    • CLASSIFY_TEXT (SNOWFLAKE.CORTEX)
                                      • COMPLETE (SNOWFLAKE.CORTEX)
                                        • COMPLETE multimodal (images) (SNOWFLAKE.CORTEX)
                                          • EMBED_TEXT_768 (SNOWFLAKE.CORTEX)
                                            • EMBED_TEXT_1024 (SNOWFLAKE.CORTEX)
                                              • ENTITY_SENTIMENT (SNOWFLAKE.CORTEX)
                                                • EXTRACT_ANSWER (SNOWFLAKE.CORTEX)
                                                  • FINETUNE (SNOWFLAKE.CORTEX)
                                                  • PARSE_DOCUMENT (SNOWFLAKE.CORTEX)
                                                    • SENTIMENT (SNOWFLAKE.CORTEX)
                                                      • SUMMARIZE (SNOWFLAKE.CORTEX)
                                                        • TRANSLATE (SNOWFLAKE.CORTEX)
                                                        • Aggregate functions
                                                          1. AI_AGG
                                                            • AI_SUMMARIZE_AGG
                                                            • Helper functions
                                                              1. AGENT_RUN (SNOWFLAKE.CORTEX)
                                                                • COUNT_TOKENS (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)
                                                                                    • TRY_COMPLETE (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-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

                                                                                                                                                        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 APIs

                                                                                                                                                        Snowflake REST APIs

                                                                                                                                                        Snowflake CLI