FLOOR

The FLOOR function returns the next whole number down from the resulting value if the value has a fractional part.

FLOOR Syntax

Use the following syntax when incorporating the FLOOR function in queries:

FLOOR(expression)

Where expression evaluates to a numeric value. If an input value is a whole number, FLOOR returns the input value.