Syntax

 

<round function> ::=

 

|

 

ROUND ( <numeric value expression> )

BROUND ( <numeric value expression> )

 

 

Notes

 

The ROUND function returns the value of the argument rounded to the closest whole number (scale 0).



 

The BROUND function uses the "Banker's Rounding" algorithm to calculate the result.



 

The data type of the result is the same type as the argument.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

ROUND( 6.5 )

7.0

BROUND( 6.5 )

6.0

ROUND( 7.5 )

8.0

BROUND( 7.5 )

8.0

 

 


 

Conformance

 

NexusDB extensions

-

-

ROUND function

BROUND function