dongyi4420 2012-06-04 10:28
浏览 79
已采纳

使用php或MySql将时间戳转换为DateTime

I've been looking for more then 40 minutes now and I can't get it done.

I got this query:

$query = "SELECT id, title, timestamp FROM adafruit_articles ORDER BY timestamp ASC";

If I echo the timestamp in php then I get:

[timestamp] => 2012-04-30 19:14:59

I would like to get the month of it with a leading zero. I can convert the timestamp to a integer but not to DateTime.

If I'm correct the last step would be:

date_format($date, "m")

but how can I get a DateTime of it?

In case MySQL is able to return only the month, I need also use the whole date somewhere so only returning the month from MySQL isn't what I'm looking for.

  • 写回答

2条回答 默认 最新

  • dongqian1893 2012-06-04 10:32
    关注

    I think this is what you want:

    $unix_timestamp = strtotime($row['timestamp']);
    $date = date('m', $unix_timestamp);
    

    m: Numeric representation of a month, with leading zeros

    http://php.net/manual/en/function.date.php

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?