[RESOLVED] DIfference In Two Timedate Fields

[Tracer]

I have two timedate fields in a table, and I am desperately trying to get an SQL (MySQL 3.xx) statement to determine the time difference between the two. I am currently using this query:

round(((end_time-start_time)/60), 2) as backup2

Which works great as long as both times are on the same DAY - but if the start_time is 11:00pm DEC 1, and the end time is 2:00am DEC 2 the numbers are all wrong.

Maybe I should just do this in PHP?

TIA

[Tracer]

Resolving my own thread - just in case anyone else needs the solution int he future

if you first convert the MySQL DateTImes to Unix TImestamps, then subtract, divide the total seconds by 60 = minutes elapsed

((UNIX_TIMESTAMP(end_time)-UNIX_TIMESTAMP(start_time))/60) as backup2