WEEKDAY function

This function calculates the day number within a week from a value of DATE type. The number of the day is between 1 (Monday) and 7 (Sunday).

The function's parameter is an expression of DATE type.

If the parameter contains a value of DATE type, the result of the function is a value of NUMBER type. If the parameter contains a NULL value, the result of the function is also NULL. Other values are invalid and cause the query to end with an error.

See also: Functions of Query Language