ceil(X)

Returns the smallest integer greater than or equal to the given value. The result is a decimal data type.

Syntax

ceil(X)

Input

Argument Type Description
X any numeric type A numeric value

Return Value

Returns a decimal value corresponding to the smallest integer greater than or equal to X.

If X is N/A, the result is N/A.

Sample Usage

<table cols="int_value,dec_value" types="i,f">
 1,-5.25;
 2,5.0;
 3,13;
 4,4.5;
 5,5.0;
</table>
<willbe name="ceil_int_example" value="ceil(int_value)"/>
<willbe name="ceil_dec_example" value="ceil(dec_value)"/>
<colord cols="int_value,ceil_int_example,dec_value,ceil_dec_example"/>

Example

In this example, the ceil(X) function returns the smallest integer greater than or equal to the given value of the cost column on the pub.demo.retail.item table. The new column contains decimal data type values.

<base table="pub.demo.retail.item"/>
<colord cols="transid, account, store, date, sku, cost"/>
<willbe name="ceilcost" value="ceil(cost)"/>