DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • AISQL
              1. Scalar functions
                1. AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_EMBED
                    • AI_FILTER
                      • AI_SIMILARITY
                        • 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. COUNT_TOKENS (SNOWFLAKE.CORTEX)
                                                    • SEARCH_PREVIEW (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
                                                                                                                              • 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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                                                            Language: English
                                                                                                                            • English
                                                                                                                            • Français
                                                                                                                            • Deutsch
                                                                                                                            • 日本語
                                                                                                                            • 한국어
                                                                                                                            • Português