ROUND (number)

ROUND returns a number rounded to a specified number of places to the right of the decimal point.

Return Value

NUMBER

Syntax

ROUND(n [, integer ])

Arguments

n is the number to round.

integer is the number of decimal places of the rounded number.

Example

ROUND(15.193,1) returns the value 15.20.

ROUND(15.193,-1) returns the value 20.00.

Copyright © 2003, 2007, Oracle. All rights reserved.