tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Uma Maheswar" <>
Subject Inserting DATE into SQL server
Date Mon, 11 Feb 2002 18:00:43 GMT
I wanted to insert date values into the database in SQL Server.The data 

type I used in SQL server is "DATETIME". I have <select> tags used in 

HTML page to ask the user select the date. I am doing it in this way

month = request.getParameter("month");
date = request.getParameter("date");
year = request.getParameter("year");

totdate = month+"/"+date+"/"+year;

insert into test values('"+totdate+"');

I get error in Tomcat saying that the data type or the number of 

columns are mismatched. How do I insert date into SQL server.

Thanks for any help.


  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message