Difference between revisions of "ROUND()"

Revision as of 05:56, 25 October 2011

Purpose

Function to return rounded numeric

Syntax

ROUND(<expN1> [,<expN2>])

See Also

CEILING(), FLOOR(), INT(), LENNUM(), SET DECIMALS, SET FIXED, TRANSFORM()

Description

The ROUND() function rounds the numeric expression <expN1> to <expN2> decimal places. If <expN2> is omitted then it is taken as zero. If the SET FIXED command is ON, <expN2> can not be greater than the number of decimal places specified by the SET DECIMALS command.

Example

? round(3.467)
      3.00
? round(3.467,1)
      3.50
? round(3.467,2)
      3.47

Products

Recital, Recital Server