how to format the mongoDate function properly

Question

I am not sure if I'm doing this right, however the date function seems to display correctly, but for some reason it is returning the time in AM not PM, Example,

Right now, if I was to create a new date using:

$time = new mongoDate();

Then I save that on the data base, in the record it displays like so:

ISODate("2014-10-22T00:22:34.619Z")

Am assuming there's something I'm not doing correctly, but when I then format it, using:

date('d M, Y h:ia', $time->sec)

It display like so:

22 Oct, 2014 12:22am

I'm hoping this is something extremely obvious, but from what I can tell in the ISOdate, it's displaying in AM time, so my question is, why is it storing it in AM and not PM?

The time is Zulu time or GMT which is likely different from your current timezone. Storing dates in GMT is best practice. — Neil Lunn, Oct 22 '14 at 01:26

score 1 · Accepted Answer · answered Oct 22 '14 at 09:03

$time->sec has unix timestamp. When you use this timestamp in date() function, formated date will be based on your set timezone. That is why you are getting 12hour difference.

$dt = new DateTime("@" . $time->sec); // DateTime instance in Z (zulu) timezone
print_r($dt); // print the object
$dt->setTimezone(new DateTimezone('... set your timezone ...'));
print_r($dt); // print the object

how to format the mongoDate function properly

1 Answers1