Numbers & math Scalar

floor()

Rounds the number down

Arguments & returns

3 overloads

Scalar

SELECT floor(17.4);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

UNIFORM(1, 10, RANDOM())

In DuckDB

CAST(FLOOR(1 + RANDOM() * (10 - 1 + 1)) AS BIGINT)