# CEIL

> CEIL function in StackQL: round a numeric argument up to the nearest integer.

Source: https://stackql.io/language-spec/functions/math/ceil

Rounds a numeric argument up to the nearest integer.  

See also:  
[[`SELECT`]](/language-spec/select) 

* * * 

## Syntax

```sql
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

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