FLOOR

Represents the SQLite FLOOR() function, which rounds a number down to the next lowest integer.

For example, FLOOR(5.9) returns 5, FLOOR(-5.1) returns -6, and FLOOR(5.0) returns 5.

The result is returned as an integer type (Long). If the input is null or a value that cannot be converted to a number, the result is null.

Return

A KQLiteColumn of type Long with the rounded-down integer value.

Author

MOHAMMAD AZIM ANSARI

Parameters

x

The column containing the numeric value to round down.

See also