| Newsgroups |
gmane.comp.db.mysql.java |
| Message-ID |
<[email protected]> |
Hi All,
I am getting jave sql exception when I am trying to retrive start_time and
end-time values from MSQL database to calculate elapsed_time in minutes.
Here is the code, please help me see what I am doing wrong
Time stime = res.getTime("starttime");
Time etime = res.getTime("endtime");
long elapsedTime = (etime.getTime()- stime.getTime());
System.out.println("Elapsed time is: "+ elapsedTime);
stat.executeUpdate("UPDATE timing SET duration = elapsedTime");
I will appreciate any help that can help me manipulate this data.
Thanks in advance.
Rgds,
Paul.
-------------------------------------------
For super low premiums, click here http://www.webmail.co.za/dd.pwm
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/[email protected]