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