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