Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • User and Cluster Administration
                      • Reference
                        • Configuration Reference
                          • SingleStoreDB Operator Reference
                            • SingleStore Tools Reference
                              • SQL Reference
                                • SQL Command Syntax
                                • SQL Commands List
                                • SQL Functions List
                                • Comparison Operators and Functions
                                  • Database Object Case-Sensitivity
                                  • Data Types
                                    • Character Encoding
                                      • Operations that Take Either a Database or a Cluster Level Lock
                                        • User-Defined Variables
                                          • Restricted Keywords
                                            • Aggregate Functions
                                              • Cluster Management Commands
                                                • Code Generation Functions
                                                  • Conditional Functions
                                                    • Data Definition Language DDL
                                                      • Data Manipulation Language DML
                                                        • Date and Time Functions
                                                          • Distinct Count Estimation Functions
                                                            • Full-Text Search Functions
                                                              • Geospatial Functions
                                                                • Identifier Generation Functions
                                                                  • Information Functions
                                                                    • JSON Functions
                                                                      • Numeric Functions
                                                                        • ABS
                                                                        • SIGN
                                                                        • EXP
                                                                        • ACOS
                                                                        • ASIN
                                                                        • ATAN
                                                                        • ATAN2, ATAN
                                                                        • BIT_COUNT
                                                                        • bitwise AND (&)
                                                                        • bitwise NOT (~)
                                                                        • bitwise OR (|)
                                                                        • bitwise XOR (^)
                                                                        • bitwise left shift (<<)
                                                                        • bitwise right shift (>>)
                                                                        • CEIL
                                                                        • CONV
                                                                        • COS
                                                                        • COT
                                                                        • LN
                                                                        • LOG2
                                                                        • LOG10
                                                                        • DEGREES
                                                                        • FLOOR
                                                                        • LOG
                                                                        • PI
                                                                        • POW
                                                                        • RADIANS
                                                                        • RAND
                                                                        • ROUND
                                                                        • SIGMOID
                                                                        • SIN
                                                                        • SQRT
                                                                        • TAN
                                                                        • TO_NUMBER
                                                                        • TRUNC
                                                                        • TRUNCATE
                                                                      • Operational Commands
                                                                        • Pipelines Commands
                                                                          • Procedural SQL Reference
                                                                            • Regular Expression Functions
                                                                              • Resource Pool Commands
                                                                                • Security Management Commands
                                                                                  • SHOW Commands
                                                                                    • String Functions
                                                                                      • Time Series Functions
                                                                                        • Vector Functions
                                                                                          • Window Functions
                                                                                          • Troubleshooting Reference
                                                                                            • System Databases
                                                                                            • Information Schema Reference
                                                                                              • Data API
                                                                                                • Code Engine - Powered by Wasm
                                                                                                • Security
                                                                                                  • Release Notes
                                                                                                    • Support
                                                                                                      • Glossary
                                                                                                      1. Self-Managed v8.0
                                                                                                      2. /
                                                                                                      3. ...
                                                                                                      4. /
                                                                                                      5. Numeric Functions

                                                                                                      Numeric Functions

                                                                                                      In this section

                                                                                                      • ABS
                                                                                                      • SIGN
                                                                                                      • EXP
                                                                                                      • ACOS
                                                                                                      • ASIN
                                                                                                      • ATAN
                                                                                                      • ATAN2, ATAN
                                                                                                      • BIT_COUNT
                                                                                                      • bitwise AND (&)
                                                                                                      • bitwise NOT (~)
                                                                                                      • bitwise OR (|)
                                                                                                      • bitwise XOR (^)
                                                                                                      • bitwise left shift (<<)
                                                                                                      • bitwise right shift (>>)
                                                                                                      • CEIL
                                                                                                      • CONV
                                                                                                      • COS
                                                                                                      • COT
                                                                                                      • LN
                                                                                                      • LOG2
                                                                                                      • LOG10
                                                                                                      • DEGREES
                                                                                                      • FLOOR
                                                                                                      • LOG
                                                                                                      • PI
                                                                                                      • POW
                                                                                                      • RADIANS
                                                                                                      • RAND
                                                                                                      • ROUND
                                                                                                      • SIGMOID
                                                                                                      • SIN
                                                                                                      • SQRT
                                                                                                      • TAN
                                                                                                      • TO_NUMBER
                                                                                                      • TRUNC
                                                                                                      • TRUNCATE

                                                                                                      Last modified: November 17, 2022

                                                                                                      Was this article helpful?

                                                                                                      TO_JSON
                                                                                                      ABS

                                                                                                      Product

                                                                                                      • Product Overview
                                                                                                      • Solutions
                                                                                                      • Pricing
                                                                                                      • Support

                                                                                                      Community

                                                                                                      • Forums
                                                                                                      • Developer Hub
                                                                                                      • Events
                                                                                                      • Training

                                                                                                      Company

                                                                                                      • Contact Us
                                                                                                      • Blog
                                                                                                      • Careers
                                                                                                      • SingleStore Connect

                                                                                                      This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                      • © SingleStore
                                                                                                      • |

                                                                                                      • Privacy Policy
                                                                                                      • |

                                                                                                      • Terms of Service
                                                                                                      • |

                                                                                                      • Legal Terms and Conditions

                                                                                                      Was this article helpful?