<div>
true. The result should be an integer of some sort (after all, it is NOT a time, you understand this ? ;-)<br />
<br />
but you could format it to a TIME value using the various &quot;date and time functions&quot;<br />

</div>


true. The result should be an integer of some sort (after all, it is NOT a time, you understand this ? ;-)

but you could format it to a TIME value using the various "date and time functions"


<div>
Also : TIMEDIFF(ARGUMENTS)<br />
<br />
(added in 4.1.1.)
</div>


Also : TIMEDIFF(ARGUMENTS)

(added in 4.1.1.)

<div>
in fact, I suggest you simply do SEC_TO_TIME(timediff)
</div>


in fact, I suggest you simply do SEC_TO_TIME(timediff)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I want to substract two TIME column values, and insert the resultant value in a third TIME column. What is the best way to do this?<br />
<br />
I tried using the basic - operator but the resultant value is not a TIME value, so I can not insert it in the third column.<br />
<br />
Thanks
</div>
</div>


Hi,

I want to substract two TIME column values, and insert the resultant value in a third TIME column. What is the best way to do this?

I tried using the basic - operator but the resultant value is not a TIME value, so I can not insert it in the third column.

Thanks

Substracting TIME values

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.