ROUND_MONTH
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 month by setting its DAY, HOUR, MINUTE, SECOND and MILLISECOND values to their ground state.
Syntax
ROUND_MONTH ( 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 month.
|