DOCUMENTATION
/
Language
English
Français
Deutsch
日本語
한국어
Português
Get started
Guides
Developer
Reference
Release notes
Tutorials
Status
For AI agents: documentation index at /llms.txt — fetch to discover all Snowflake documentation pages. Markdown version of this page: /en/sql-reference/functions-numeric.md
  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_FUNCTION_EVALUATION
                          • AI_FUNCTION_OPTIMIZATION
                            • AI_MULTI_EMBED
                              • AI_PARSE_DOCUMENT
                                • AI_REDACT
                                  • AI_SENTIMENT
                                    • AI_SIMILARITY
                                      • AI_SUMMARIZE
                                        • AI_SUMMARIZE_AGG
                                          • AI_TRANSCRIBE
                                            • AI_TRANSLATE
                                              • FINETUNE (SNOWFLAKE.CORTEX)
                                              • SENTIMENT (SNOWFLAKE.CORTEX)
                                                • Helper functions
                                                  1. AGENT_RUN (SNOWFLAKE.CORTEX)
                                                    • DATA_AGENT_RUN (SNOWFLAKE.CORTEX)
                                                      • THREAD_MESSAGES (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
                                                                                                                                            • Period
                                                                                                                                            • 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