MySQL: ROUND Function
This MySQL tutorial explains how to use the MySQL ROUND function with syntax and examples.
Description
The MySQL ROUND function returns a number rounded to a certain number of decimal places.
Syntax
The syntax for the ROUND function in MySQL is:
ROUND( number, [ decimal_places ] )
Parameters or Arguments
- number
- The number to round.
- decimal_places
- The number of decimal places to round. This value must be a positive or negative integer. If this parameter is omitted, the ROUND function will round the number to 0 decimal places.
Note
Applies To
The ROUND function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL ROUND function examples and explore how to use the ROUND function in MySQL.
For example:
mysql> SELECT ROUND(125.315); Result: 125 mysql> SELECT ROUND(125.315, 0); Result: 125 mysql> SELECT ROUND(125.315, 1); Result: 125.3 mysql> SELECT ROUND(125.315, 2); Result: 125.32 mysql> SELECT ROUND(125.315, -1); Result: 130 mysql> SELECT ROUND(125.315, -2); Result: 100 mysql> SELECT ROUND(-125.315); Result: -125
Advertisements