Home » SQL & PL/SQL » SQL & PL/SQL » Date Range
Date Range [message #336138] Fri, 25 July 2008 00:22 Go to next message
sweetkhaliq
Messages: 200
Registered: April 2006
Senior Member

Dear Members
I am using oracle 9i. I want to show dates between the range of dates by using the dual table. Suppose i want to show the dates between sysdate and sysdate+7.

Thanks & regards.
Re: Date Range [message #336140 is a reply to message #336138] Fri, 25 July 2008 00:34 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Search for Infinite Dual on Google.

Regards,
Rajat
Re: Date Range [message #336142 is a reply to message #336138] Fri, 25 July 2008 00:37 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Search for "calendar".

Regards
Michel
Previous Topic: UTL - Check is file existed
Next Topic: Avoiding Full table Scans
Goto Forum:
  


Current Time: Tue Feb 11 01:56:58 CST 2025