Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
on Jul 27, 2012 5:39 AM by Johnreardon
Jul 26, 2012 8:46 PM
My Requirement is to pull the data from the certain table based on the start and End date.
For example i have the below structure of the table
Userid StartDate EndDate
101 01/05/2012 12/31/9999
102 01/04/2012 01/06/2012
103 03/20/2012 01/05/2012
Like this the dates will be there. Now i want to pull all the records for duration 01/05/2012 to 05/31/2012. Do i need to use the between function or
i should use the below Query
SELECT * FROM T1 where Startdate<='05/31/2012' and Enddate>='01/05/2012'.
Thanks for your response
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Date Range
Jul 27, 2012 5:39 AM
in response to
His this is the Oracle DEsigner forum. Try the
SQL and PL/SQL