Skip to main content

FLOOR

Rounds a numeric argument down to the nearest integer.

See also:
[SELECT]

Syntax​

SELECT FLOOR(numeric_expression) FROM <multipartIdentifier>;

Arguments​

numeric_expression
An expression of the exact numeric or approximate numeric data type category.

Return Value(s)​

Returns the largest integer less than or equal to the specified numeric expression.

Examples​

Round down a floating point number to the closest (smaller) integer​

SELECT name, timeCreated,
floor(julianday('now')-julianday(timeCreated)) as days_since_ceiling
FROM google.storage.buckets WHERE project = 'stackql';