# ceil

[Read this page in HTML](https://www.scopedb.io/docs/reference/functions/numeric/ceil)

Rounds a number toward positive infinity.

## Syntax

```scopeql
ceil(<expr>)
```

## Arguments

| Argument | Type    | Description  |
| -------- | ------- | ------------ |
| `<expr>` | `float` | Input value. |

## Returns

Returns `float`. Returns NULL if the input is NULL.

## Usage notes

For an `int` or `uint` column, cast the value to `float` before calling this function.

## Examples

Convert call durations into started minutes: any partial minute counts as another minute.

```scopeql
VALUES ('call-17', 61.0), ('call-42', 120.0), ('call-63', 149.0)
SELECT $0 AS call_id, $1 AS duration_seconds
SELECT call_id, duration_seconds, ceil(duration_seconds / 60.0) AS started_minutes
```

```text
+---------+------------------+-----------------+
| call_id | duration_seconds | started_minutes |
+---------+------------------+-----------------+
| call-17 | 61.0             | 2.0             |
| call-42 | 120.0            | 2.0             |
| call-63 | 149.0            | 3.0             |
+---------+------------------+-----------------+
```