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