sql - How to fetch records from DB2 for the last 7 days (1 WEEK) from today

Question

I am using DB2. I want to fetch records for this week from a column. I want to use similar to below (This is for SQL 2005)

Select count(*) from Applications WHERE ReceivedDate is this week. (Last 7 days including today)

Answer 1

Try a WHERE clause like this:

WHERE ReceivedDate > current date - 7 days