Urgent sql query [message #373516] |
Fri, 20 April 2001 08:08 |
CHACKO
Messages: 11 Registered: March 2001
|
Junior Member |
|
|
How can I retrieve data in weekly basis?
For eg:
From Jan 01,2000 to till present
Any help is appreciated
Thanks
|
|
|
Re: Urgent sql query [message #373517 is a reply to message #373516] |
Fri, 20 April 2001 08:15 |
Miguel
Messages: 14 Registered: April 2001
|
Junior Member |
|
|
Something like this:
select *
from XXX
where trunc(revised_date) >= trunc(sysdate-7)
This will grab data where a revised_date
is 7 days old or newer.
HTH
|
|
|
|
|