ROUND
Description
ROUND
is a row function that rounds a numeric value to the specified number of decimal places and returns a value of type DOUBLE
.Syntax
ROUND
(numeric_expression
,number_decimal_places
)Return Value
Returns one value per row of type
DOUBLE
.Input Parameters
- numeric_expression
- Required. A field or expression of any numeric type.
- number_decimal_places
- Required. An integer that specifies the number of decimal places to round to.
Examples
Round the number
32.4678954
to two decimal places:ROUND(32.4678954,2) returns
32.47