Calculating Time Difference In Minutes between 2 times 1

[bobrivers2003]

I have two columns in a table start_time and end_time (stored as datetime). I wish to work out the time difference in minutes between these two values. If the difference is 1hr 30 minutes I wish to get 90 (mins)

I have tried:

SELECT TIME_FORMAT(TIMEDIFF(start_time, end_time), '%i') FROM table ... This returns justs the minutes (e.g. 30)

and

SELECT TIME_FORMAT(start_time - end_time, '%i') FROM table .... no such luck.


Any help would be greatly appreciated

 

[r937]

select ( unix_timestamp(end_time)
        -unix_timestamp(start_time) ) / 60
  from ...

r937.com | rudy.ca

 

[bobrivers2003]

Thank you r937. It works a treat