Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

Numeric literal example:


Output: Generates 3.

Expression example:

ceiling(MyValue + 2.5)

Output: Returns the smallest integer that is greater than the sum of 2.5 and the value in the MyValue column.


ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column or Decimal or Integer literal to apply to the function


Name of the column, numeric literal, or numeric expression.

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal2.5

Example - Exponential functions