Ceiling

Summary

The Ceiling function returns the smallest integer greater than or equal to a numeric expression.

Syntax

Ceiling(<numeric_exp>)

Return Type

The type corresponding to the numeric input.

Details

 

Examples

select Ceiling(-1.2) from Empty(rows=1);
-1
select Ceiling(10.0) from Empty(rows=1);
10
select Ceiling(10.2345) from Empty(rows=1);
11

Related Functions