I need to subtract 2 'TIME' type fields from a MySQL table. They are essentially a 'START' and and 'END'. The differences are always either 1 or 1.5 hours. If I simply use a query like (end)-(start) AS Diff, I get a long number (ex. 13000, this might be UNIX time??) After reading the MySQL documentation, it looks like I should be using either TIMEDIFF or SUBTIME. However, neither of these seem to work properly. I have also tried the following, but it returns '0' for my time difference. SELECT sec_to_time(unix_timestamp(end)-unix_timestamp(start)) AS Diff Any suggestions?