php - 将日期时间结果偏移 3 小时

Question

我有这段查询数据库的 PHP 代码:

  $result = mysqli_query($con,"SELECT * FROM `ur_destination` WHERE `destination_name` IN ($id)");

echo "<table class='datagrid'>
<tr>
<td>Start date & time GMT</td>
<td>End date & time GMT</td>
</tr>
";

while($row = mysqli_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['active_period_start_time'] . "</td>";
  echo "<td>" . $row['active_period_end_time'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

结果如下所示:2014-04-27 10:50:00那么如何在开始和结束时间的结果中添加 +3 小时的偏移量呢？谢谢。

Answer 1

试试这个

{
  echo "<tr>";
  echo "<td>" . date("Y-m-d H:i:s",strtotime("+3 hours",strtotime($row['active_period_start_time']))) . "</td>";
  echo "<td>" . date("Y-m-d H:i:s",strtotime("+3 hours",strtotime($row['active_period_end_time']))). "</td>";
  echo "</tr>";
}