Calculating the sum of time differences

[ro1960]

I have the following query:

SELECT DATE_FORMAT(date_start, '%d/%m/%Y') AS Fdate_start, TIMEDIFF(date_end,date_start) AS calc_duration, type, type_detail, category FROM `delegation` WHERE (date_start >= '$date_start' and date_end <= '$date_end')

I want to be able to add all the calc_duration in the results as total_duration for example.

I tried some solutions with SUM but got nowhere.

[r937]

does this help? --
http://www.sitepoint.com/forums/showthread.php?t=644910

[PHPycho]

I have the following query:

SELECT DATE_FORMAT(date_start, '%d/%m/%Y') AS Fdate_start, TIMEDIFF(date_end,date_start) AS calc_duration, type, type_detail, category FROM `delegation` WHERE (date_start >= '$date_start' and date_end <= '$date_end')

I want to be able to add all the calc_duration in the results as total_duration for example.

I tried some solutions with SUM but got nowhere.

Standard way of doing

WHERE (date_start >= '$date_start' and date_end <= '$date_end')

to

WHERE ('$date_start' BETWEEN date_start and date_end)

[r937]

um, dear phpycho, those are not the same!!