Returns a number from 1 to 7 representing the day of the week of a date, where Sunday=1, Monday=2, and so on.
DOW( date-expression )
date-expression The date to evaluate.
The DOW function is not affected by the value specified for the first_day_of_week database option. For example, even if first_day_of_week is set to Monday, the DOW function returns a 2 for Monday.
SQL/2003 Vendor extension.
The following statement returns the value 5.
SELECT DOW( '1998-07-09' );
The following statement queries the Employees table and returns the employees StartDate, expressed as the number of the day of the week:
SELECT DOW( StartDate ) FROM Employees;