how to retrieve data from table with runtime values in sql?

how to retrieve data from table with runtime values in sql? For example, I have table with column (date, movie1, movie2,movie3).Now whenever I pass different dates into the method(which performs database retrieval actions) My ResulSet has to execute the command with the dates which I pass. I know how to retrieve a particular value. But I dont know how to retrieve the values whenever i pass different dates to method. Please help me.

Thanks Praveen.

March 31, 2012 at 4:26 PM

Have a look at the following link:

http://www.roseindia.net/sql/sqldate/sql-date-comparison.shtml