Name

round() — Round off numeric values

Common Usage

round( value )
round( value, precision )

Description

The round() function returns a floating-point value that represents value rounded to precision base-10 digits after the decimal point. The value parameter is assumed to be a floating-point value, while precision is assumed to be a positive integer. Values are rounded to the closest representation, not towards zero.

If either value or precision is NULL, a NULL will be returned. If precision is omitted, it is assumed to be zero. This will result in a whole number, although it will still be returned as a floating-point value.