floor

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

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

Description

The floor function takes the floor of a number x.

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

from {
  x: floor(3.4),
  y: floor(3.5),
  z: floor(-3.4),
}

{
  x: 3,
  y: 3,
  z: -4,
}

from {
  x: floor(2024-02-24, 1y),
  y: floor(1h52m, 1h)
}

{
  x: 2024-01-01,
  y: 1h,
}