php - 如何从mysql表中获取我的本地时间

Question

列 date 是 timestamp - 默认 - current_timestamp

示例值:2017-04-07 09:45:53

$stmt = $db->query("select * from cinema order by date desc");
    while($row = $stmt->fetch()){
        $date = strtotime($row['date']);
        $datea = date("d-m-y", $date);
        $time = date("H:i", $date);

与我的时区相比，我的时差为 -2 小时 - 09:45 而不是 11:45 - 所以我尝试了:

$stmt = $db->query("SELECT *, CONVERT_TZ(date, '+00:00', '+01:00') FROM cinema order by date desc"); - without success

我还尝试将列类型从 timestamp (current_timestamp) 更改为 datetime (current_timestamp)。

仍然有 -2 小时的差异。

有什么帮助吗？

Answer 1

你可以试试这样的:

$stmt = $db->query("SELECT *, CONVERT_TZ(date, @@session.time_zone, '+02:00') AS mydate FROM cinema order by mydate desc");

以下是一些在处理日期和时间时可能会有帮助的读物: https://stackoverflow.com/a/19075291/1363190