ROUND_DAY
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
This function rounds a DATE input down to the day by setting its HOUR, MINUTE, SECOND and MILLISECOND values to their ground state.
Syntax
ROUND_DAY ( table.date_column )
NULL handling
If the input value is NULL, then the result is NULL as well.
Example
[1] Round dates down to the day.
|