I have a **txn** (transaction) table which has a datetime field named **post\_ts**, which is the field that represents the date of the transaction.
I am writing the code for a batch job (which is supposed to be a weekly job to be run on Sundays) using Spring Batch, and I need to run the query such that I need to fetch all transactions from a week back to the date I am running the job.

Apart from other million business rules to be applied to the query, I need the transactions from (currentdate) to (current date - 7)