ROUND()

From Recital Documentation Wiki
Revision as of 09:07, 2 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Numeric Data


Purpose

Function to return rounded numeric


Syntax

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


See Also

CEILING(), FLOOR(), INT(), 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 Database Server, Recital Mirage Server, Recital Terminal Developer