This is version 1 2 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

ROUND#

Functionality: #

This Oracle function will return number rounded to the indicated number of decimal places.

Parameters:#

NUMBER	The original number
PLACES	(optional) The number of decimal places (default is 0)

Returns: #

Number

Errors:#

None

Example:#

round(~) will return 3 if the value passed is from 3.00 to 3.499999 and 4 if the value is 3.50000 to 3.999999 round(~,2) will round the number passed to 2 decimal places