floor
The floor function rounds down to the largest previous integer value. Returns the largest integer not greater than x.
Syntax
floor(<x>) as <field>
Examples
floor(1.5) as v // v = 1floor(-1.5) as v // v = -2
The floor function rounds down to the largest previous integer value. Returns the largest integer not greater than x.
floor(<x>) as <field>floor(1.5) as v // v = 1floor(-1.5) as v // v = -2