Printing A MongoDB Date From PHP

Question

How in PHP do I get the regular timestamp format out of a MongoDB date?

Assume I have:

$my_date;
print_r($my_date);

The print_r output is:

MongoDate Object ( [sec] => 1346300336 [usec] => 593000 )

But doing:

echo $my_date;

Outputs:

0.59300000 1346300336

Even tried:

echo (string)$my_date

Same thing.

Answer 1

$my_date->sec is the unix timestamp, use date() function to show it in required format.

echo date('Y-m-d H:i:s', $my_date->sec);

Answer 2

Just a quick update, to say that MongoDate has a toDateTime method since the version 1.6 of the pecl extension. You can now do

$mongoDate->toDateTime()->format(...)