Rounds a value to a specified number of decimal places.

​
Syntax

ROUND(<value> [, <decimal>])

​
Parameters

ParameterDescriptionSupported 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: