i have used prepared statement to insert date values in database..it is inserting..but the prob.. is that it cannot display date in dd-MON-yy format.i.e 26-jan-04

my query is like that:

java.util.Date dt1 = sdf.parse(request.getParameter("chq_date"));//inserts in database

pstmt.setDate(1, new java.sql.Date(dt1.getTime()));

<td><input value="<%= rs.getDate("chq_date") %>" name="chq_date"></td>//displays date

Well you have display the date according to your needs. The database returns the date format - that it understands. You need to manipulate it for your display purposes.