php存储日期时间,以UTC格式存储日期和时间，并在PHP / MySQL中转换它们的本地时间...

默认情况下，Unix时间戳始终为UTC。如果我们以UTC格式将时间戳存储在数据库中，我们只需要使用以下PHP脚本：

$TZ_UTC = new DateTimeZone('UTC'); //-->Database Timezone;

$TZ_LOCAL = new DateTimeZone('America/New_York'); //-->Expected Local Timezone from user settings;

//--Example Database Query--

while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {

//---If we want to show UTC timezone directy----

echo $row['action_timestamp'];

//---If we want to show LOCAL timezone from user settings----

$dateObj = new DateTime($row['action_timestamp'], $TZ_UTC);

$dateObj->setTimezone($TZ_LOCAL); //--> Here is the conversion!

echo $dateObj->format("Y-m-d H:i:s T");

}

?>