Floor
Returns a number rounded down to the next lower integer.
Format
Floor ( number )
Parameters
number - any numeric expression or field containing a numeric expression
Data type returned
number
Originated in version
7.0
Example 1
Floor(1.25) returns 1.
Floor(-1.25) returns -2.