DAY_OF_WEEK
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
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
Syntax
DAY_OF_WEEK ( table.column )
NULL handling
If any parameter is NULL, the result is NULL as well.
Example
[1] In this example the result for every weekday is shown, beginning from Sunday. |