 |
| SQL DAYOFWEEK scalar function in SQL DB2 for i |
DAYOFWEEK
The DAYOFWEEK function returns an integer from 1 to 7 i.e. day of the week where 1 is Sunday and 7 is Saturday.
Syntax
DAYOFWEEK(expression)
The argument should be an expression that returns either date, timestamp, character string, graphic string data type. The return value is the large integer. Also, the result can be NULL if the argument value is null.
Example#1:
If the argument is a string.
SELECT DAYOFWEEK('2024-03-16') FROM sysibm.sysdummy1
16th March 2024 is Saturday. Therefore, returns 7
DAYOFWEEK
7
Or
SELECT DAYOFWEEK('2024-03-16-15.10.40.456465') FROM sysibm.sysdummy1
DAYOFWEEK
7
Example#2:
The result can be null if the argument is null.
Create a table having date field and that allows null value to be inserted.
CREATE TABLE QTEMP/DT (DATE1 DATE )
INSERT INTO QTEMP/DT VALUES(null)
Output
DATE1 -
select DAYOFWEEK(date1) from qtemp/dt
DAYOFWEEK ( DATE1 )
-
Returns NULL value as date1 field has NULL value in table qtemp/dt.
Example#3:
If the argument is a timestamp, the result is the date part of the timestamp.
SELECT DAYOFWEEK(current timestamp) FROM sysibm.sysdummy1
Or
SELECT DAYOFWEEK(current_timestamp) FROM sysibm.sysdummy1
DAYOFWEEK
7
Example#4:
Argument value is the character string '2024076', which represents a date in the format yyyynnn, where yyyy is the year, and nnn is the day of the year.
SELECT DAYOFWEEK('2024076') FROM sysibm.sysdummy1
DAYOFWEEK
7