我有下一个代码:
$startTrip = DateTime::createFromFormat('Y-m-d H:i:s', $s);
echo $s; echo '=>';
$select2 = "SELECT eventDate from workDayPrint where eventDate >'".$item['eventDate']."' order by eventDate asc limit 1";
$end_get = mysqli_query($con, $select2);
$endArr = mysqli_fetch_array($end_get);
$e =$endArr[0];
$endTrip= DateTime::createFromFormat('Y-m-d H:i:s', $e);
echo $e; echo '=>';
if($endTrip != null ){
$interval = $endTrip->diff($startTrip);
echo $interval->format('%h:%i'); echo '<br>';
$sum->add($interval);
echo $sum->format('H:i'); echo '<br>';
我想总计$ interval的值(00:42 00:10 00:30 ......) . 我已尝试过dateTime,但似乎是从00:00和$ interval进行差异
求和的结果不正确,看起来像make diff:
2018-10-02 00:08:00=>2018-10-02 00:50:00=>0:42
23:18
2018-10-03 06:31:00=>2018-10-03 06:32:00=>0:1
23:17
2018-10-04 01:29:00=>2018-10-04 01:32:00=>0:3
23:14
任何想法?
非常感谢!