floor¶

Description¶

Returns ‘val’ rounded down to the given ‘precision’. Precision defaults to 0, meaning the value will be rounded to the nearest integer.

int64

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

floor( val [ , precision ] )

Argument	Type	Required	Multiple
val	numeric	Required	Only one
precision	int64	Optional	Only one

make_col rounded:floor(@.temperature, 2)

Return the rounded down value of column temperature with 2 decimals