ROUND

The ROUND function rounds a number to a specified number of decimal places.

If the number of decimal places is not specified, the number is rounded to a whole number. The result is in character number format.

Syntax:
ROUND (single-number-expression [ , single-integer-expression ])
Meaning:
ROUND (number_to_round [ , number_of_decimal_places ])
Returns:
A single number

ROUND converts number_to_round to character format, if necessary, and then produces the value of number_to_round rounded to the number of decimal places specified by number_of_decimal_places. If number_of_decimal_places is not specified, number_to_round is rounded to the nearest whole number.

Examples

  • ROUND (1.46, 1)

    Returns 1.5

  • ROUND (1.46)

    Returns 1

Related functions

  • TRUNCATE