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