Skip to main content

CEIL

Rounds a numeric argument up to the nearest integer.

See also:
[SELECT]

Syntax​

SELECT CEIL(numeric_expression) FROM <multipartIdentifier>;

Arguments​

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

Return Value(s)​

Returns the smallest integer greater than or equal to the specified numeric expression.

Examples​

Round up a floating point number to the closest (larger) integer​

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