Difference between revisions of "ROUND()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
==Class==
 
Numeric Data
 
  
  

Revision as of 16:06, 28 October 2009


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 Database Server, Recital Mirage Server, Recital Terminal Developer