let's say i have a table named tblData and has 4 columns: data_RefNo, data_DateReported, data_TargetDate, data_DatatblData returns 2 rows.data_RefNo.............data_DateReported.............data_TargetDate........................data_Data10000................10-20-2004 10:55:44 AM........10-20-2004 10:57:44 AM........Slow Response Time10000................10-21-2004 10:55:44 AM........10-21-2004 11:55:44 AM........Bug Errori just wana ask how to get the difference of the date_DateReported and date_TargetDate._______________i tried this code but it didnot workpublic Vector get_con_pf(){ Vector vData = new Vector(); String query = "SELECT * FROM tblData WHERE data_RefNo= '"'10000'"'"; try { DBConnect db = new DBConnect(); db.openCon(); ResultSet rs = db.execute(query); while (rs.next()) { vData.addElement(DATEDIFF(mi, rs.getString("st_DateReported"), rs.getString("st_TargetFinishDate"))); } db.closeCon(); } catch (Exception e) { System.out.println("Error: " + e ); } return vData; }_____________________i want to return the difference of the data_DateReported and date_TargetDate, i did thisvData.addElement(DATEDIFF(mi, rs.getString("st_DateReported"), rs.getString("st_TargetFinishDate")));but it didnot work.How do i get that? because i want to return a vector._____________________the code must return the values:2 for the 1st rows because the difference is only 2 minutes, and60 for the 2nd row.
How to get the difference of two dates?
Posted - 2004-10-20 : 23:19:49
