<div>
Is the duration field datetime or varchar?
</div>


Is the duration field datetime or varchar?

<div>
maybe this:<br />
<br />
SEC_TO_TIME(<br />
hour(mydt)*60*60 +<br />
minute(mydt)*60 +<br />
second(mtdt)<br />
)<br />
<br />
check all date &amp;&nbsp;time functions here<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_hour" rel="ugc">http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_hour</a>
</div>


maybe this:

SEC_TO_TIME(
hour(mydt)*60*60 +
minute(mydt)*60 +
second(mtdt)
)

check all date & time functions here

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_hour [http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_hour]

<div>
something like this:<br />
<br />
select <br />
SEC_TO_TIME(sum(<br />
hour(mydt)*60*60 +<br />
minute(mydt)*60 +<br />
second(mtdt)<br />
)<br />
)<br />
from my table where ...
</div>


something like this:

select
SEC_TO_TIME(sum(
hour(mydt)*60*60 +
minute(mydt)*60 +
second(mtdt)
)
)
from my table where ...

<div>
Perfect thanks very much :)
</div>


<div>
but my solution is basically the same one that you posted :(<br />
<br />
TIME(mydt) = hour(mydt)*60*60 + minute(mydt)*60 + second(mtdt)<br />

</div>


but my solution is basically the same one that you posted :(

TIME(mydt) = hour(mydt)*60*60 + minute(mydt)*60 + second(mtdt)


<div>
My appologies,<br />
<br />
I actually mis-read your solution, if there is a way for me to split the points at this stage I'm happy to do so, soryy :(
</div>


My appologies,

I actually mis-read your solution, if there is a way for me to split the points at this stage I'm happy to do so, soryy :(

<div>
I'm sorry HainKurt, I didn't want to steal your solution, I was unaware of it, we just posted at the same time (you faster, it took me more time to explain my solution).<br />
I'd be happy to share my points with you, if possible :)<br />
<br />
BrianFord, glad to help! :)
</div>


I'm sorry HainKurt, I didn't want to steal your solution, I was unaware of it, we just posted at the same time (you faster, it took me more time to explain my solution).
I'd be happy to share my points with you, if possible :)

BrianFord, glad to help! :)

<div>
<div class="content wysiwyg-content">
Using MySQL.<br />
<br />
I have a field called 'duration' that has data in the format &nbsp;'1899-12-31 00:08:55'<br />
<br />
I ned to sum up the TIME portion of this field and show th result as HH:MM:SS, what would the sql synax be fo this??
</div>
</div>


Using MySQL.

I have a field called 'duration' that has data in the format  '1899-12-31 00:08:55'

I ned to sum up the TIME portion of this field and show th result as HH:MM:SS, what would the sql synax be fo this??

Summing time fields to get total time

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.