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

You can format the date string before dislpaying it in the text box.

Please check the following link for date formats example:

http://www.codetoad.com/asp/format_date_time.asp

Om Prakash