_day_of_week

Returns the day of the week (between 1 and 7) for "timestamp_expression" where "integer_expression" indicates which day of that week is day 1. To determine "integer_expression", choose the day of the week and count from Monday; for example, if you choose Wednesday, "integer_expression" would be 3 because Wednesday is the third day from Monday.

Syntax

_day_of_week ( timestamp_expression , integer_expression )

Example

_day_of_week ( 2009-01-01 , 7 ), where 7 means that Sunday is the 
first day of the week.

Result