on 11-27-2017 6:51 AM
From your question and your comments I can only guess what you require (sorry :)).
If you are searching for a function which allows you to calculate a date 7 days in the past and a date 7 days in the future, you can use the ADD_DAYS function.
Following dummy query should explain you how to do it:
SELECT current_date AS "Current Date", add_days(current_date, -7) AS "Current Date - 7 days", add_days(current_date, 7) AS "Curent Date + 7 days" FROM DUMMY;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.