I have written jsp code to insert date in oracle
but its giving error null.my code is:
please help me on this....
thanx in advance...
but its giving error null.my code is:
Code:
String query="insert into test_KMS_DATA_ROW values('"+rocode+"','"+roname+"',"+activityId+",'"+activity+"',"+duration+",to_date("+startdate+",MM/DD/YYYY HH24:MI:SS),'"+starttime+"',to_date("+enddate+",MM/DD/YYYY HH24:MI:SS),'"+endtime+"','"+startby+"','"+endby+"','"+d+"','N')";
stmt1=con.createStatement();
int n=stmt1.executeUpdate(query);
please help me on this....
thanx in advance...