Applies to: CELONIS 4.0CELONIS 4.2CELONIS 4.3CELONIS 4.4CELONIS 4.5CELONIS 4.6CELONIS 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 ROUND_WEEK function
is handled slightly different: This function also rounds down the HOUR, MINUTE, SECOND and MILLISECOND values,
but the DAY value will not be in its ground state. Instead, the day will be chosen as the Monday of the week
of that date.