The MongoDate class

(PECL mongo >=0.8.1)


Represent date objects for the database. This class should be used to save dates to the database and to query for dates. For example:

Example #1 Storing dates with MongoDate


// save a date to the database
$collection->save(array("ts" => new MongoDate()));

$start = new MongoDate(strtotime("2010-01-15 00:00:00"));
$end = new MongoDate(strtotime("2010-01-30 00:00:00"));

// find dates between 1/15/2010 and 1/30/2010
$collection->find(array("ts" => array('$gt' => $start'$lte' => $end)));


MongoDB stores dates as milliseconds past the epoch. This means that dates do not contain timezone information. Timezones must be stored in a separate field if needed. Second, this means that any precision beyond milliseconds will be lost when the document is sent to/from the database.

Class synopsis

MongoDate {
/* Fields */
public int $sec ;
public int $usec ;
/* Methods */
public __construct ([ int $sec = time() [, int $usec = 0 ]] )
public string __toString ( void )

Table of Contents

add a note add a note

User Contributed Notes 2 notes

jhonnydcano at yahoo dot com
4 years ago
For showing a human readable MongoDate, you can use something like this:

('Y-M-d h:i:s', $yourDate->sec);
richard at securebucket dot com
2 years ago
I wanted a way to check the age of a record.  This code will calculate the time between the creation date of the record, and return the seconds.  I use it for caching pages similar to the max-age header in a browser.  If the record is older, than my limit it deletes itself.

function microtime_diff( $start, $end=NULL ) {
        if( !
$end ) {
$end= microtime();
$start_usec, $start_sec) = explode(" ", $start);
$end_usec, $end_sec) = explode(" ", $end);
$diff_sec= intval($end_sec) - intval($start_sec);
$diff_usec= floatval($end_usec) - floatval($start_usec);
floatval( $diff_sec ) + $diff_usec;

To Top