ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DOW function [Date and time]

Function 

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

Syntax 

DOW ( date-expression )

Parameters 

date-expression    The date.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns the value 5.

SELECT DOW( '1998-07-09' )