NexusDB V3 Manual
Round Function
|
|
NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions
|
Syntax
<round function> ::=
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
|
|
© Nexus Database Systems Pty Ltd.