Progress
SQL-92
Guide and Reference


DAYOFWEEK Function

Returns the day of the week in the argument as a short integer value in the range of 1-7.

The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.

SYNTAX

DAYOFWEEK ( date_expression ) 

EXAMPLE

The following example shows how to use the DAYOFWEEK function:

SELECT *
    FROM orders
    WHERE DAYOFWEEK (order_date) = 2 ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095