JSP database access date and time of issue emergency ~~~ ~ ~ I use ACCESS, JSP Table mm increase in a date / time field datetime The successful insertion of a web Date / time recording formats such as : 2005-6-5 14:3:43 But I want to use after this date / time record has always appeared content to find "Grammar and standard database is not the same type of" error, consult the 4003rd database access previous page insert date / time record, I kept as SESSION, so in this page Call String times= (string) session.getValue ( "adate"); ResultSet knee String sql3= "select*from mm where datetime= '" +times+ "'"; Rs=view.executeQuery (sql3); While (rs.next ()) String lnn=rs.getString ( "name");         %> "Concerning         "P><%=lnn%></p> <%}%> Overall, I think the intention is to insert a record, passing the record of the date / time (eg : 2005-6-5 14:3:43) find this record, and he read the "name" field I tried with other investigations, and that is to use the date / time will not do I think I will not use this data with the DATE, I would like to ask why they master, Please write the language correctly and to achieve my intention, I would like to thank the ~

I do not know Bangniding 顶~

This is because the format jsp to obtain the field with the time that you have thus not the same format as a result, you need to change to match, even encountered such a problem landlord.

String sql3= "select*from mm where datetime=#" +times+ "#"; Attempt # Types to increase its access date, but I do not remember clearly written specifically how

[ Closed window ]