|
View previous topic :: View next topic
|
| Author |
Message |
AJAYREDDY
New User
Joined: 17 Feb 2007
Posts: 52
Location: USA
|
|
|
|
I need data from a DB2 table from given date back to 10 days.
For example if I give date as 09/18/2015 - 10 days I need only all the records from 10 days behind 09/18/2015.
I am trying this query but its failing. I seen examples for CURRENT DATE - 10 days but not for ANY GIVEN DATE - 10 days. Can someone please let me know the query.
SELECT * FROM QUAL.MYTABLE WHERE DATE_COL >= '09/18/2015' - 10 DAYS; |
|
| Back to top |
|
 |
RahulG31
Active User
Joined: 20 Dec 2014
Posts: 446
Location: USA
|
|
|
|
Use DATE function. Try this:
| Code: |
| SELECT * FROM QUAL.MYTABLE WHERE DATE_COL >= DATE('09/18/2015') - 10 DAYS; |
. |
|
| Back to top |
|
|
|
|
