Through BatchSqlUpdate how to insert date data as MM/DD/YYYY HH:MM:SS?
Here is my code
String insert_Query ="insert into table ("+
"student_id,student_name,admission_date) values (?,?,?)";
BatchSqlUpdate updater = new BatchSqlUpdate(getDataSource(), insert_Query);
updater.declareParameter(new SqlParameter(Types.VARCHAR));
updater.declareParameter(new SqlParameter(Types.VARCHAR));//app_id
updater.declareParameter(new SqlParameter(Types.DATE));
updater.compile();
System.out.println("After updater");
while (rs.next()) {
System.out.println("Inside While");
Object[] values = new Object[3];
values[0] = rs.getString("student_id");
values[1] = rs.getString("student_name");
//Here arrival_time is Epoch time. e.g. value will be like '1316363322','1316377882'
Long dateTemp1 = null;
dateTemp1 = rs.getLong("admission_date");
values[2] = new java.util.Date (dateTemp1*1000);
//With SOP we are getting value as Sun Sep 18 19:52:08 IST 2011 for new java.util.Date (dateTemp1*1000);
//After the insertion into oracle database the value is only 09/18/2011
// How to get the value as 09/18/2011 19:52:08
//In Oracle the admission_date column datatype is Date
System.out.println(new java.util.Date (dateTemp1*1000));
updater.update(values);
}
updater.flush();