Syntax
DAY_OF_WEEK(Argument)
Description
The DAY_OF_WEEK SQL scalar function returns an integer between 1 and 7 that represents the day of the week, where 1 represents Monday.
The argument must be a date, or a timestamp.
The result of the function is an integer.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Note the following peculiarities:
- With DB2/400 and DB2/UDB, the ISO implementation of the DAYOFWEEK (DAYOFWEEK_ISO) function is used.
With SQL Server, the ISO implementation is forced by using the "SET DATEFIRST 1" option.
With ODBC, the result cannot be guaranteed, as the implementation of the function can vary according to the destination DBMS.
Example
Assume ORDER_DATE is February 15, 2003
DAY_OF_WEEK(ORDER_DATE) returns 6.
List of SQL scalar functions by topic