DOCUMENTATION
/
Getting Started
Guides
Developer
Reference
Releases
Tutorials
Snowflake Open Catalog
Status
  1. Overview
    • SQL data types reference
    • SQL command reference
    • Function and stored procedure reference
        1. Summary of functions
          • All functions (alphabetical)
            • Aggregate
            • 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
                                                                                    • Regular expressions
                                                                                    • Semi-structured and structured data
                                                                                    • 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 Terms© 2025 Snowflake, Inc. All Rights Reserved.
                                                                                  Language: English
                                                                                  • English
                                                                                  • Français
                                                                                  • Deutsch
                                                                                  • 日本語
                                                                                  • 한국어
                                                                                  • Português