Is it Monday ? 2

[redbank]

I need to determine the day of the week from the current timestamp or any timestamp come to that.

Also the Monday Date of the current week - i.e. if it is Wednesday, what was Monday's date.

I am using IBM's mainframe DB2 tool SPUFI.

 

[PruSQLer]

Select dayname(current timestamp), count(*)
From Table1

That will get you the day of the week. Do you want to get the full date of Monday when it's Wednesday, Thursday, etc?
If so, you could do a case statement like this:

select case when day(current timestamp) = 3 then
Date(current timestamp - 1 days)
case when day(current timestamp) = 4 then
Date(current timestamp - 2 days)
ETC ,
Count(*)
From table1

Hopefully SPUFI lets you do that.

 

[r937]

use DAYOFWEEK or DAYOFWEEK_ISO function

http://www-3.ibm.com/cgi-bin/db2www...d2w/report?fn=db2v7s0sqls0459.htm#HDRFNDAYOFW

to get date of previous monday, you will need something like

date( current_date
- ( dayofweek(current_date) + 1 ) days
)

rudy

http://rudy.ca/

 

[redbank]

Whoops !

I had overlooked that we are on a new release of DB2 which now contains
DAYOFWEEK.

In previous releases this was unavailable.