documentationfloor¶
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¶
prec
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
floor( val [ , precision ] )
Argument |
Type |
Required |
Multiple |
Constant |
|---|---|---|---|---|
val |
numeric |
Required |
Only one |
Variable |
precision |
int64 |
Optional |
Only one |
Constant |
Examples¶
make_col rounded:floor(@.temperature, 2)
Return the rounded down value of column temperature with 2 decimals