floor¶
Description¶
Returns ‘val’ rounded down to the given ‘precision’.
Precision defaults to 0, meaning the value will be rounded to the nearest integer.
Return type¶
float64
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
floor(val, [ precision ])
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
val |
numeric |
no |
no |
none |
precision |
int64 |
yes |
no |
constant |
Examples¶
make_col rounded:floor(@.temperature, 2)
Return the rounded down value of column temperature with 2 decimals