List of Previous Dates

Hi,

I'm after a way to create an oracle view that will list the dates in YYYY-MM-DD format of the previous month.
i.e.


2007-05-01
2007-05-02
2007-05-03
2007-05-04
.......etc

I need this to be dynamic enough so each time I select the view it will give me an updated list. All dates of June for example if I select the view in July.

Is this possible? say by selecting from the table dual?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories