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 = 1
floor(-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 = 1
floor(-1.5) as v // v = -2