<div>
This is how you would do it in PHP...<br />
<br />
&lt;?php<br />
$total=&quot;239:35:36&quot;;<br />
list($hours,$minutes,$seco<wbr />nds)=explo<wbr />de(&quot;:&quot;,$to<wbr />tal);<br />
echo floor($hours/24).&quot; days &quot;.($hours%24).&quot; minutes &quot;.$seconds.&quot; seconds.&quot;;<br />
?&gt;
</div>


This is how you would do it in PHP...

<?php
$total="239:35:36";
list($hours,$minutes,$seconds)=explode(":",$total);
echo floor($hours/24)." days ".($hours%24)." minutes ".$seconds." seconds.";
?>

<div>
whoops, this should be right<br />
&lt;?php<br />
$total=&quot;239:35:36&quot;;<br />
list($hours,$minutes,$seco<wbr />nds)=explo<wbr />de(&quot;:&quot;,$to<wbr />tal);<br />
echo floor($hours/24).&quot; days &quot;.($hours%24).&quot; hours &quot;.$minutes.&quot; minutes &quot;.$seconds.&quot; seconds.&quot;;<br />
?&gt;
</div>


whoops, this should be right
<?php
$total="239:35:36";
list($hours,$minutes,$seconds)=explode(":",$total);
echo floor($hours/24)." days ".($hours%24)." hours ".$minutes." minutes ".$seconds." seconds.";
?>

<div>
Any idea how to do it in mysql? &nbsp;I have played with all the date functions, but can never seem to get it quite right.
</div>


Any idea how to do it in mysql?  I have played with all the date functions, but can never seem to get it quite right.

<div>
That is exactly perfect. &nbsp;Thank you so much.
</div>


That is exactly perfect.  Thank you so much.

<div>
sorry for such a long delay. &nbsp;I didn't realize that I had not accepted the answer 
</div>


sorry for such a long delay.  I didn't realize that I had not accepted the answer

<div>
<div class="content wysiwyg-content">
I have this query:<br />
<br />
SELECT timediff(stop_time,start_t<wbr />ime) as total from `work`;<br />
which gives me this<br />
<br />
239:53:36<br />
<br />
where 239 is hours, 53 is minutes and 36 is seconds.<br />
<br />
Instead, I want it to 9 days 5 hours, 53 minutes etc<br />
<br />
I could either do this from mysql or php, though i would prefer to do it from mysql.<br />
<br />
I have mysql version 5.0.11 running on suse sles 9
</div>
</div>


I have this query:

SELECT timediff(stop_time,start_time) as total from `work`;
which gives me this

239:53:36

where 239 is hours, 53 is minutes and 36 is seconds.

Instead, I want it to 9 days 5 hours, 53 minutes etc

I could either do this from mysql or php, though i would prefer to do it from mysql.

I have mysql version 5.0.11 running on suse sles 9

Convert mysql date to days hours minutes seconds

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.

MySQL Server

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.