DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
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_EXTRACT
                      • AI_FILTER
                        • AI_PARSE_DOCUMENT
                          • AI_SENTIMENT
                            • AI_SIMILARITY
                              • AI_TRANSCRIBE
                                • 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_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
                                                                                                                                      Join the conversation
                                                                                                                                      Develop with Snowflake
                                                                                                                                      Share your feedback
                                                                                                                                      Read the latest on our blog
                                                                                                                                      Get your own certification
                                                                                                                                      Privacy NoticeSite TermsCookies Settings© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                                                                      Language: English
                                                                                                                                      • English
                                                                                                                                      • Français
                                                                                                                                      • Deutsch
                                                                                                                                      • 日本語
                                                                                                                                      • 한국어
                                                                                                                                      • Português