Subtracting mysql time field

[Anon]

I knwo you can subtract and add mysql date fields but is there a way to say

select id, (time1 - time2) as time from mytable;

I wan to be able to find the amount of elapsed between two times.

Also I use military time in my database

thanks

[majik-sheff]

This should produce the result you're looking for:

SELECT SEC_TO_TIME(TIME_TO_SEC(time1) - TIME_TO_SEC(time2)) AS time FROM mytable;