MariaDB: FORMAT Function
This MariaDB tutorial explains how to use the MariaDB FORMAT function with syntax and examples.
Description
The MariaDB FORMAT function formats a number as a format of '#,###.##', rounding it to a certain number of decimal places and then it returns the result as a string.
Syntax
The syntax for the FORMAT function in MariaDB is:
FORMAT( number, decimal_places )
Parameters or Arguments
- number
- The number to format.
- decimal_places
- The number of decimal places to round the number.
Note
- If decimal_places is 0, then the FORMAT function returns a string with no decimal places.
Applies To
The FORMAT function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB FORMAT function examples and explore how to use the FORMAT function in MariaDB.
For example:
SELECT FORMAT(1287.635, 2); Result: '1,287.64' SELECT FORMAT(1287.635, 1); Result: '1,287.6' SELECT FORMAT(1287.635, 0); Result: '1,288'
Advertisements