SQL Function Reference

ROUND

Returns a number rounded to the specified number of decimal places

MySQL

ROUND(num, [decimals])

num

Initial fractional number

decimals

Number of decimal places to round a number

The number of decimal places can be positive or negative and, at the same time, no more than 30 (or -30, in the case of a negative value). If it is negative, then the digits to the left of the decimal point of the number num become zero, and the fractional part is cut off.

Examples

MySQL

SELECT ROUND(22.29);

MySQL

SELECT ROUND(22.29, 1);

MySQL

SELECT ROUND(22.29, -1);