Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Returns the day of the week as number. The operator returns for Sunday 0, for Monday 1, for Tuesday 2 and so on.
Supported input column types: DATE
Output column type: INT
DAY_OF_WEEK ( table.column )
If any parameter is NULL, the result is NULL as well.
[1] In this example the result for every weekday is shown, beginning from Sunday. |