Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

DateTime rounding

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

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: