Skip to main content

FLOOR

Returns the largest integer less than or equal to the specified numeric expression.

Syntax​

FLOOR ( 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 FLOOR function.

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

Response:

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