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