How to fetch records from DB2 for the last 7 days (1 WEEK) from today Try a WHERE clause like this: WHERE ReceivedDate > current date - 7 days