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