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

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

$TZ_UTC &＃61; new DateTimeZone(&＃39;UTC&＃39;); //-->Database Timezone;

$TZ_LOCAL &＃61; new DateTimeZone(&＃39;America/New_York&＃39;); //-->Expected Local Timezone from user settings;

//--Example Database Query--

while($row &＃61; mysqli_fetch_array($result, MYSQLI_ASSOC)) {

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

echo $row[&＃39;action_timestamp&＃39;];

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

$dateObj &＃61; new DateTime($row[&＃39;action_timestamp&＃39;], $TZ_UTC);

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

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

}

?>