I would like to query Oracle 9i database to get information from a table between a given time period.
My code passes me two Strings, which I convert into date (using SimpleDateFormat). One of these strings correspond to "Start Date" and the other one refers to "End Date". E.g, Start Date can be "11/23/2004" and End Date can be "12/23/2004".
Now, my question is: Assuming there exists a column "MyDates" in a table, how do I get all the information (from the other columns in my table) between MyDates = '11/23/2004' and MyDates = '12/23/2004' ?
Do I have to resort to some kind of PL/SQL stuff or is this achievable via Java (JDBC) ?