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
The FLOOR function rounds an input value to the nearest integer that is less than it.
SELECT FLOOR(…)
FLOOR(constant)
FLOOR(fact)
FLOOR(metric)
FLOOR(metric_expression)
SELECT FLOOR(12.2) = 12
SELECT FLOOR(12.7) = 12