A developer asked me, how do I find the date for last Sunday. It was a Wednesday when he asked. After some thinking, this is what I gave him as solution. This works in DB2, not sure about other databases.
SELECT CURRENT DATE - (DAYOFWEEK(CURRENT DATE) - 1) DAYS
FROM SYSIBM.SYSDUMMY1
This solution works only for Sunday. For Monday, change 1 to 2, for Tuesday 3 and so on.
I've not done an extensive testing, so take it with a grain of salt :)
