Numeric functions
ROUND
Reference material for ROUND function
Rounds a value to a specified number of decimal places.
Syntax
Parameters
Parameter | Description | Supported input types |
---|---|---|
<value> | The value to be rounded | |
<decimal> | Optional. An INTEGER constant that defines the decimal range of the returned value. By default, ROUND returns whole numbers. | INTEGER |
Return Types
DOUBLE PRECISION
Example
The following example returns the rounded value of 5.4. Since there is no specification of the decimal range, the functions returns a whole number:
The following example rounds the value 5.6930 to 1 decimal place: