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

* | floor(-1.5) as v