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_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