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

Question

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.

Answer 1

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