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)
                                                                    • 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
                                                                                                                                              Share your feedback
                                                                                                                                              Privacy PolicyTerms of Service
                                                                                                                                              © 2026 Snowflake All Rights Reserved.@北京神州数码云计算有限公司版权所有.

                                                                                                                                              Alternative interfaces

                                                                                                                                              Snowflake Python APIs

                                                                                                                                              Snowflake REST APIs

                                                                                                                                              Snowflake CLI