circle-info
Webinar | The Great Database Exodus: Navigating Strategic Risk in the Post-Oracle MySQL Era
Watch Nowarrow-up-right
LogoLogo
search
⌘Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good night

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • serverMariaDB Server Documentation
  • rabbit-runningQuickstart Guides
  • tvServer Usage
  • gearServer Management
  • shield-halvedSecurity
  • house-blankArchitecture
  • wrenchClients & Utilities
  • chart-mixedHA & Performance
  • paperclipReference
    • SQL Structure
    • SQL Statements
    • SQL Functions
      • Functions & Operators
      • Aggregate Functions
      • Control Flow Functions
      • Date & Time Functions
      • Numeric Functions
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEIL
        • CEILING
        • CONV
        • COS
        • COT
        • CRC32
        • CRC32C
        • DEGREES
        • DIV
        • EXP
        • FLOOR
        • LN
        • LOG
        • LOG10
        • LOG2
        • MOD
        • OCT
        • PI
        • POW
        • POWER
        • RADIANS
        • RAND
        • ROUND
        • SIGN
        • SIN
        • SQRT
        • TAN
        • TO_NUMBER
        • TRUNCATE
      • Pseudo Columns
      • Secondary Functions
      • Special Functions
      • String Functions
      • Vector Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. paperclipReferencechevron-right
  2. SQL Functions

Numeric Functions

Learn about numeric functions in MariaDB Server. This section details SQL functions for performing mathematical calculations, rounding, and manipulating numeric values in your queries.

ABSchevron-rightACOSchevron-rightASINchevron-rightATANchevron-rightATAN2chevron-rightCEILchevron-rightCEILINGchevron-rightCONVchevron-rightCOSchevron-rightCOTchevron-rightCRC32chevron-rightCRC32Cchevron-rightDEGREESchevron-rightDIVchevron-rightEXPchevron-rightFLOORchevron-rightLNchevron-rightLOGchevron-rightLOG10chevron-rightLOG2chevron-rightMODchevron-rightOCTchevron-rightPIchevron-rightPOWchevron-rightPOWERchevron-rightRADIANSchevron-rightRANDchevron-rightROUNDchevron-rightSIGNchevron-rightSINchevron-rightSQRTchevron-rightTANchevron-rightTO_NUMBERchevron-rightTRUNCATEchevron-right
PreviousYEARWEEKchevron-leftNextABSchevron-right

Last updated 7 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.

Was this helpful?