Difference between revisions of "ROUND()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Numeric Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return rounded numeric
 
Function to return rounded numeric
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[CEILING()]], [[FLOOR()]], [[INT()]], [[SET DECIMALS]], [[SET FIXED]], [[TRANSFORM()]]
+
[[CEILING()]], [[FLOOR()]], [[INT()]], [[LENNUM()]], [[SET DECIMALS]], [[SET FIXED]], [[TRANSFORM()]]
  
  
Line 31: Line 27:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data Functions]]
 
[[Category:Numeric Data Functions]]

Latest revision as of 15:23, 7 December 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, Recital Server