Returns a number from 1 to 7 representing the day of the week of a date, where Sunday=1, Monday=2, and so on.

Syntax

DOW( date-expression )

Parameters

Returns

SMALLINT

Remarks

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.

Standards and compatibility

Example

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;