Difference between revisions of "CEILING()"

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 the smallest integer that is greater than or equal to a given value
 
Function to return the smallest integer that is greater than or equal to a given value
Line 31: Line 27:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Numeric Data]]
 +
[[Category:Numeric Data Functions]]

Latest revision as of 16:07, 27 November 2009

Purpose

Function to return the smallest integer that is greater than or equal to a given value


Syntax

CEILING(<expN>)


See Also

BETWEEN(), FLOOR(), ISDIGIT(), MAX(), MIN(), SIGN()


Description

The CEILING() function is used to return the smallest integer that is greater than or equal to a given value in the numeric expression <expN>.


Example

? ceiling(354.89)
       355
? ceiling(354.19)
       355
? ceiling(-354.89)
      -354


Products

Recital Server, Recital