How to calculate difference between old date/time captured in mysql and present date

[Syed Khaleel Ahamed]

Dear Sir,

I want to get the difference of date/time captured in mysql and present date/time in jsp.
I am using the following code to get, but its getting difference only in hrs, i used split strings in jsp for that, can u please help me in this code, i have to get difference in min and sec also.

<%@ page  import="java.sql.*,java.text.SimpleDateFormat" %>
 
<%! int x; %>
 
<%
 
String EmployeeId;// = request.getParameter("EmployeeId");
EmployeeId = session.getAttribute("ssnEmployeeId").toString();
 
x = 0;
 
 
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aams","root","root");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select employeename from admin where employeeid='"+EmployeeId+"' and flag = 0");
 
if(rs.next()){
   //String employeeid=(String) session.getAttribute("employeeid");
 
    //if(employeeid.equals(employeeid) == true ){
 
   //  session.setAttribute("employeeid",employeeid);
 
//System.out.println("Reached");
    rs = st.executeQuery("select intime from admin where employeeid = '"+ EmployeeId+ "' and flag = 0 ");
    rs.next();
 
     java.util.Date now = new java.util.Date();
      String DATE_FORMAT = "dd-hh";
      SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
 
    String strDateNew = sdf.format(now) ;
 
 
 
String s3 = rs.getString(1);
      String [] temp = null;
      temp = s3.split("-");
 
 
String strDate = temp[2], strTime = temp[3];
//System.err.println("Reached");
 
      s3 = strDateNew;
      temp = null;
      temp = s3.split("-");
      int curtime, oldtime;
      curtime = Integer.parseInt(temp[1]);
      oldtime = Integer.parseInt(strTime);
 
      System.out.println("Current Time" + curtime);
      System.out.println("Old Time" + oldtime);
      System.out.println("Current Date" + strDate);
 
      if(curtime<oldtime)
          {
          curtime=curtime+12;
          }
 
 
      int diff = curtime - oldtime;
 
      if(strDate.equals(temp[0]) == false || diff >=8)
          {
    %>
<jsp:forward page="checkout.jsp" />
    <%
    }
      else{
          int total=diff;
          diff = 8-diff;
          session.setAttribute("ssnTimeDifference", diff);
          session.setAttribute("totaltime", total);
          response.sendRedirect("warning.jsp");
          }
}
else{
    %>
 
    <jsp:forward page="CheckIn.jsp" />
    <%
}
 
%>

Please help me in this code to get both min and sec...