Skip to main content

Celonis Product Documentation

DateTime Rounding
Description

DateTime rounding functions round down the subordinates of the chosen time unit into the ground state. They can be applied to DATE columns and always return a DATE column.

The ground states are:

  • MONTH: 01

  • DAY: 01

  • HOUR: 00

  • MINUTE: 00

  • SECOND: 00

  • MILLISECOND: 000

The following functions are available: