Date Search by Last week/Month

Hello All,

This will be my first post on here. Plus I'm a new oracle user just started learning about 1 week ago.

I have a create a report for our dept with certain criteria. So far what I need is a report that shows last weeks numbers or sign ups. I can't get the date search or between to work. Can someone help me on this?

What I need is one for month end and one for last 7 days.


here's what I have so far.



select ap.name

to_char(ap.opendate,'MM-DD-YY') "Open Date"


from [databasname]

where ap.opendate between databasename-7 and databasename-1


I really don't want to change the date myself I want the system to know when the 7 days or month is.

Can you post sample data and create table script?

I doubt very much the rdbms you are using will allow you to subtract a number form the databasename string.

Think about it and back to the drawing board...

Thank you both for trying to help me. I was able to figure out how to use the date search.

AND (ap.boxes <'31-Oct-2011')
AND (ap.boxes >'01-Oct-2011')
search for previous month.


--And this one too.

where ap.boxes <> sysdate and ap.boxes >= sysdate-8
search 7 days back.

Good!