floor Function

The floor function rounds down to the largest previous integer value. Returns the largest integer not greater than x.

Syntax

floor(<x>) as <field>

Example

floor(1.5) as v // v = 1

floor(-1.5) as v // v = -2