Home » SQL & PL/SQL » SQL & PL/SQL » Get last 5 dates (Oracle 10g)
Get last 5 dates [message #313256] Fri, 11 April 2008 04:40 Go to next message
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
Re: Get last 5 dates [message #313261 is a reply to message #313256] Fri, 11 April 2008 04:55 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
And what have you tried?
Re: Get last 5 dates [message #313265 is a reply to message #313256] Fri, 11 April 2008 05:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...And search?
There are many topics on calendar.

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


Current Time: Sun Dec 04 06:33:13 CST 2016

Total time taken to generate the page: 0.04423 seconds