FLOOR

The FLOOR function rounds an input value to the nearest integer that is less than it.

Syntax

SELECT FLOOR(…)
FLOOR(constant)
FLOOR(fact)
FLOOR(metric)
FLOOR(metric_expression)

Examples

SELECT FLOOR(12.2) = 12
SELECT FLOOR(12.7) = 12