mongodb分组查询 php,MongoDB与PHP聚合 – 按日期分组

您可以将这些部分投影出来,然后对它们进行分组,以便您可以对整个日期进行分组：

$results = $c->aggregate(array(

array(

'$project' => array(

'year' => array('$year' => '$executed' ),

'month' => array('$month' => '$executed' ),

'day' => array('$dayOfMonth' => '$executed')

),

),

array(

'$group' => array(

'_id' => array('year' => '$year', 'month' => '$month', 'day' => '$day'),

'count' => array('$sum' => 1)

),

),

array(

'$sort' => array(

'_id.year' => 1,

'_id.month' => 1,

'_id.day' => 1

),

),

array(

'$limit' => 30

)

));

正如你所说的那样,像你这样的东西可以帮你排序：$year- $month- $dayOfMonth.