Howdy, Stranger!

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

Categories

List of Previous Dates

ShadovvShadovv Member Posts: 31
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.