Time problem in prepared statement -> MySql
<p>When I use the code below in a prepared statement</p>

<pre><code>Date totalDate = visit.getTotalTime();
Date visitDate = visit.getVisitTime();

java.sql.Time sqlTotalTime = new java.sql.Time(totalDate.getTime() - visitDate.getTime()); 
ps.setTime(4, sqlTotalTime);
</code></pre>

<p>And I use these values</p>

<pre><code>08/Dec/2010:07:27:54
08/Dec/2010:07:27:52
</code></pre>

<p>I would expect 00:00:02 but I get 01:00:02?</p>

<p>Anyone an idea why ....</p>
