<div>
You could also transform the datetime columns to a unix timestamp, and subtract:<br />

<pre><code id="code-249514">SELECT
TimeOut,
TimeIn,
unix_timestamp(TimeOut)-
unix_timestamp(TimeIn) as TT
FROM
project_time
</code></pre>
</div>


You could also transform the datetime columns to a unix timestamp, and subtract:


SELECT
TimeOut,
TimeIn,
unix_timestamp(TimeOut)-
unix_timestamp(TimeIn) as TT
FROM
project_time


<div>
It's <br />
TIMEDIFF(TimeOut,TimeIn) as TT<br />
<br />
But you got it, thanks
</div>


It's
TIMEDIFF(TimeOut,TimeIn) as TT

But you got it, thanks

<div>
<div class="content wysiwyg-content">
I have 2 timestamp columns in a db table. One is TimeIn the other is TimeOut.<br />
<br />
What I'm trying to do is find the total time, i.e. the difference between the 2 columns. What I thought would work is just subtract the 2 but I get a weird responses.<br />
<br />
Here's my query:<br />
SELECT<br />
TimeOut,<br />
TimeIn,<br />
(TimeOut-TimeIn) as TT<br />
FROM<br />
project_time<br />
<br />
But what I get is the following:<br />
2/12/2009 10:37:40 | 2/12/2009 10:37:30 | 10<br />
2/12/2009 10:39:21 | 2/12/2009 10:37:21 | 200<br />
2/12/2009 10:40:00 | 2/12/2009 10:39:30 | 70<br />
2/12/2009 10:53:00 | 2/12/2009 10:52:00 | 100<br />
2/12/2009 11:06:28 | 2/12/2009 10:57:36 | 4892<br />
2/12/2009 11:08:04 | 2/12/2009 11:06:49 | 155<br />
<br />
What I want is the total Seconds. From there I can compute the Min &amp;&nbsp;Hours. I've also tried both Timestamp and Datetime but both had the same results.<br />

</div>
</div>


I have 2 timestamp columns in a db table. One is TimeIn the other is TimeOut.

What I'm trying to do is find the total time, i.e. the difference between the 2 columns. What I thought would work is just subtract the 2 but I get a weird responses.

Here's my query:
SELECT
TimeOut,
TimeIn,
(TimeOut-TimeIn) as TT
FROM
project_time

But what I get is the following:
2/12/2009 10:37:40 | 2/12/2009 10:37:30 | 10
2/12/2009 10:39:21 | 2/12/2009 10:37:21 | 200
2/12/2009 10:40:00 | 2/12/2009 10:39:30 | 70
2/12/2009 10:53:00 | 2/12/2009 10:52:00 | 100
2/12/2009 11:06:28 | 2/12/2009 10:57:36 | 4892
2/12/2009 11:08:04 | 2/12/2009 11:06:49 | 155

What I want is the total Seconds. From there I can compute the Min & Hours. I've also tried both Timestamp and Datetime but both had the same results.


get difference in  time from 2 timestamps

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.