Skip to Content
0
Former Member
Mar 19, 2009 at 09:18 AM

How to compare dates in a select query in open sql

438 Views

Hi

How can I retrieve data pertaining to a specified date using a select query.

I have inserted date using the following code:

String dateString = "2009-03-11";

java.sql.Date date = java.sql.Date.valueOf(dateString);

PreparedStatement stmt =con.prepareStatement("insert into DATEACCESS"

+ "(DATETEST)"

+ "values (?)");

stmt.setDate(1,date);

stmt.executeUpdate();

How can I pass this in a select query,the below mentioned query did not fetch me any results.

Select * from DATEACCESS where DATETEST='2009-03-11'