MongoDB: Search by date in PHP

Well, I answer my own question:

What happens is that when I return my query too many documents, PHP exceeds the memory limit and sends me to error. What I did to solve this problem and see results was to use "limit" as follows:

$db = $conn->r_gestiones;
$coleccion = $db->r_gestiones;
$consulta = array( "inicio_gestion"=>array('$gt'=>new MongoDate(strtotime("2015-11-16 00:00:00")), '$gte'=>new MongoDate(strtotime("2015-11-16 23:59:59"))));
$cursor = $coleccion->find( $consulta )->limit(10);

In this way I am only getting the first ten records, thus solving my problem. I hope this code is useful for you.

Here is a link to more information about how use "limit"

Thank you.

The second operator of your query, $gte , means greater than or equal , then it is almost the same as $gt . Your query returns all records after 23:59 that day. A year and a half of records.

Try the operator $lte (less than or equal) to narrow the results to the records prior to 23:59 on the date you indicate

Your query would look like this:

$consulta = [
    "inicio_gestion"=>[
        '$gte'=>new MongoDate(strtotime("2015-11-16 00:00:00")), 
        '$lte'=>new MongoDate(strtotime("2015-11-16 23:59:59"))
     ]
];

That brings all the tasks started on 2015-11-16.

If you also want to cross it with the works that ended before the end of that day:

$consulta = [
  '$and' => [
    "inicio_gestion"=>[
        '$gte'=>new MongoDate(strtotime("2015-11-16 00:00:00")), 
        '$lte'=>new MongoDate(strtotime("2015-11-16 23:59:59"))
    ],
    "fin_gestion"=>[
        '$lte'=>new MongoDate(strtotime("2015-11-16 23:59:59"))
    ]
  ]
];

In this second case, the operator $lte in the first part of the query is redundant: if ended before midnight on November 16, it is implied that started em> before midnight on November 16.