DAY_OF_WEEK
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. | ||||||||||||||||||||
| ||||||||||||||||||||
|