DOCUMENTATION
/
Language
English
中文
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
Go to https://china-status.snowflake.com to see details of the 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-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
                                                                                                                                                        Share your feedback
                                                                                                                                                        Privacy PolicyTerms of Service
                                                                                                                                                        © 2026 Snowflake All Rights Reserved.@北京神州数码云计算有限公司版权所有.

                                                                                                                                                        Alternative interfaces

                                                                                                                                                        Snowflake Python APIsSnowflake REST APIsSnowflake CLI