php - 四舍五入到最近的 5 分钟 php mysqli

Question

我正试图让这个时间代码向下舍入到最接近的时间例如，如果列出的时间是 10:28，那么我希望它显示 10:25

我有的是(需要修改时间)

<?php 
include('../../database/2ndconnection.php');

$sql="SELECT * FROM raid ORDER BY TimeRecord DESC LIMIT 1";
$result=mysqli_query($dbcon,$sql);

while($rows=mysqli_fetch_array($result)){
    $dateStr = $rows['TimeRecord'];

    $pst = new \DateTime($dateStr);
    $pst->modify("-3 hours");

    $est = new \DateTime($dateStr);
} ?>

PST: <?php echo $pst->format('H:i'); ?>
<br>EST: <?php echo $est->format('H:i'); ?>

预先感谢您的帮助

Answer 1

插入这个:

<?php
$currentMinutes = $time->format('i');
$minutesToSubtract = $currentMinutes % 5;
$time = $time->sub(new DateInterval('M' . $minutesToSubtract));
?>

$currentMinutes 将保存当前分钟数，使用 %，您可以计算需要减去的分钟数，然后通过 减去它们>子函数

它可以集成到您的代码中，如下所示:

<?php 
include('../../database/2ndconnection.php');

$sql="SELECT * FROM raid ORDER BY TimeRecord DESC LIMIT 1";
$result=mysqli_query($dbcon,$sql);

while($rows=mysqli_fetch_array($result)){
    $dateStr = $rows['TimeRecord'];

    $pst = new \DateTime($dateStr);
    $pst->modify("-3 hours");

    $est = new \DateTime($dateStr);
}

$currentMinutes = $pst->format('i');
$minutesToSubtract = $currentMinutes % 5;
$pst = $pst->sub(new DateInterval('M' . $minutesToSubtract));

?>

PST: <?php echo $pst->format('H:i'); ?>
<br>EST: <?php echo $est->format('H:i'); ?>