我只需要检索工作的总秒数，然后根据应用程序的表示层的要求将其转换为小时/分钟（毕竟，这是除以60的简单情况）：
<? $dbh = new PDO("mysql:dbname=$dbname", $username, $password); $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE); $qry = $dbh->prepare(' SELECt SUM(TIME_TO_SEC(entry_end_time)-TIME_TO_SEC(entry_start_time)) FROM entry WHERe entry_date BETWEEN :start_date AND :end_date AND user_id = :user_id '); $qry->execute([ ':start_date' => '2012-01-01', ':end_date' => '2012-12-31', ':user_id' => 3 ]); list ($totalMins, $remngSecs) = gmp_div_qr($qry->fetchColumn(), 60); list ($totalHour, $remngMins) = gmp_div_qr($totalMins, 60); echo "Worked a total of $totalHour:$remngMins:$remngSecs.";?>
