ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns a number from 1 to 7 representing the day of the week of a date, with Sunday=1, Monday=2, and so on.
DOW ( date-expression )
date-expression The date.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value 5.
SELECT DOW( '1998-07-09' )