Skip to main content

CEILING

This function returns the smallest integer greater than, or equal to, the specified numeric expression.

Syntax

CEILING ( numeric_expression )

Arguments

numeric_expression
Is an expression of the exact numeric or approximate numeric data type category.

Return Type

Returns values of type INT64.

Examples

Examples in this section use the example blockchain.

This example shows the results of using the CEILING function.

SELECT CEILING(real), CEILING(integer) FROM example;

Response:

CEILING(real) [INT64]     CEILING(integer) [INT64]
NULL -1
0 0
1 1
2 2