floor(val: numeric, [precision: const int64]?) -> float64

Returns 'val' rounded down to the given 'precision'.

Precision defaults to 0, meaning the value will be rounded to the nearest integer.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Numeric

Examples

make_col rounded:floor(@.temperature, 2)

Return the rounded down value of column temperature with 2 decimals