OraFAQ Forum: SQL & PL/SQL » Get last 5 dates

Home » SQL & PL/SQL » SQL & PL/SQL » Get last 5 dates (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Get last 5 dates [message #313256]

Fri, 11 April 2008 04:40

manishg23
Messages: 1
Registered: April 2008

Junior Member

I am struggling to find out a query which retuns last 5 dates using single query. Example : today is 11 Apr 2007 So my query should return

11 Apr 2007
10 Apr 2007
9 Apr 2007
8 Apr 2007
7 Apr 2007
6 Apr 2007

Report message to a moderator

Re: Get last 5 dates [message #313261 is a reply to message #313256]

Fri, 11 April 2008 04:55

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

And what have you tried?

Report message to a moderator

Re: Get last 5 dates [message #313265 is a reply to message #313256]

Fri, 11 April 2008 05:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

...And search?
There are many topics on calendar.

Regards
Michel

Report message to a moderator

Previous Topic:	Most disk space-efficient number type?
Next Topic:	Calling function in a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:07:27 CST 2024