Skip to main content
Version: v4.23

ceil

Computes the ceiling of a number or a time/duration with a specified unit.

ceil(x:number)
ceil(x:time, unit:duration)
ceil(x:duration, unit:duration)

Description​

The ceil function takes the ceiling of a number x.

For time and duration values, use the second unit argument to define the rounding unit.

Examples​

Take the ceiling of integers​

from {
  x: ceil(3.4),
  y: ceil(3.5),
  z: ceil(-3.4),
}
{
  x: 4,
  y: 4,
  z: -3,
}

Round time and duration values up to a unit​

from {
  x: ceil(2024-02-24, 1y),
  y: ceil(10m, 1h)
}
{
  x: 2025-01-01,
  y: 1h,
}

See Also​

floor, round