All pastes #17374 Raw Edit

Untitled

public php v1 · immutable
#17374 ·published 2005-07-10 14:58 UTC
rendered paste body
$query=("SELECT sifra, ((SELECT SUM(time_to_sec(timestamp)) FROM names WHERE reason='2' AND sifra='$id' GROUP BY (sifra)) - (SELECT SUM(time_to_sec(timestamp))....This is not entire query but I dont want to hear OMG :)), stuff any more, whell it works, but I had to use time_to_sec to get true secundes passed away but now I would like to format it to followin:format output I mean :), mysql> SELECT SEC_TO_TIME(2378);        -> '00:39:38'mysql> SELECT SEC_TO_TIME(2378) + 0;        -> 3938but whatever I pass as argument I do not get correct format out.Whell if any ideas thanks.,