The Round function is a built-in function that returns the decimal value n rounded to a specific number of fractional digits (by default, 0).

The return of the function depends on where it is used:

Where

Round method

Development environment

Round half to even (rounds to the nearest integer, 0.5 rounds the number to the nearest even integer).

(Aggregate)
SQL Server, Oracle

Round half away from 0 (rounds to the nearest integer, 0.5 rounds the number further away from 0).

(Aggregate)
MySQL, iDB2

Round half up (rounds to the nearest integer, 0.5 rounds up).

Also, in an Aggregate expression there is no optional input parameter.

Input parameters

n: mandatory; Decimal Type.
The value to be rounded.

fractionalDigits: optional; Integer Type.
Use it to specify the number of fractional digits that n has to be rounded to. The default value is 0.

Output parameters

Decimal Type

Examples

Usage

Round half to even

Round half away from 0

Round half up

Round(-10.89)

-11

-11

-11

Round(-5.5)

-6

-6

-5

Round(9.3)

9

9

9

Round(2.5)

2

3

3

Round(3.5)

4

4

4

Round(9.123456789 , 5)

9.12346

(not applicable)

(not applicable)

See Also

Trunc Function | Available Mathematical Functions | Available Built-in Functions