DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • AI Functions
              1. AI_AGG
                • AI_CLASSIFY
                  • AI_COMPLETE
                  • AI_COUNT_TOKENS
                    • AI_EMBED
                      • AI_EXTRACT
                      • AI_FILTER
                        • AI_MULTI_EMBED
                          • AI_PARSE_DOCUMENT
                            • AI_REDACT
                              • AI_SENTIMENT
                                • AI_SIMILARITY
                                  • AI_SUMMARIZE_AGG
                                    • AI_TRANSCRIBE
                                      • AI_TRANSLATE
                                        • FINETUNE (SNOWFLAKE.CORTEX)
                                        • SENTIMENT (SNOWFLAKE.CORTEX)
                                          • SUMMARIZE (SNOWFLAKE.CORTEX)
                                            • Helper functions
                                              1. AGENT_RUN (SNOWFLAKE.CORTEX)
                                                • DATA_AGENT_RUN (SNOWFLAKE.CORTEX)
                                                  • EXECUTE_AI_EVALUATION
                                                    • GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL)
                                                      • GET_AI_OBSERVABILITY_LOGS (SNOWFLAKE.LOCAL)
                                                        • GET_AI_OBSERVABILITY_EVENTS (SNOWFLAKE.LOCAL)
                                                          • GET_AI_RECORD_TRACE (SNOWFLAKE.LOCAL)
                                                            • SEARCH_PREVIEW (SNOWFLAKE.CORTEX)
                                                              • SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX)
                                                                • SPLIT_TEXT_RECURSIVE_CHARACTER (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-categoryFunctionNotes
                                                                                                                                    ArithmeticDIV0
                                                                                                                                    DIV0NULL
                                                                                                                                    Rounding and TruncationABS
                                                                                                                                    CEIL
                                                                                                                                    FLOOR
                                                                                                                                    MOD
                                                                                                                                    ROUND
                                                                                                                                    SIGN
                                                                                                                                    TRUNCATE , TRUNC
                                                                                                                                    Exponent and RootCBRT
                                                                                                                                    EXP
                                                                                                                                    FACTORIAL
                                                                                                                                    POW, POWER
                                                                                                                                    SQRT
                                                                                                                                    SQUARE
                                                                                                                                    LogarithmicLN
                                                                                                                                    LOG
                                                                                                                                    TrigonometricACOS
                                                                                                                                    ACOSH
                                                                                                                                    ASIN
                                                                                                                                    ASINH
                                                                                                                                    ATAN
                                                                                                                                    ATAN2
                                                                                                                                    ATANH
                                                                                                                                    COS
                                                                                                                                    COSH
                                                                                                                                    COT
                                                                                                                                    DEGREES
                                                                                                                                    PI
                                                                                                                                    RADIANS
                                                                                                                                    SIN
                                                                                                                                    SINH
                                                                                                                                    TAN
                                                                                                                                    TANH
                                                                                                                                    OtherWIDTH_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© 2026 Snowflake, Inc. All Rights Reserved.

                                                                                                                                    Alternative interfaces

                                                                                                                                    Snowflake Python APIsSnowflake REST APIsSnowflake CLI