+
95
-

php如何将mongodb中的时间戳字段转换成日期时间格式输出并分组?

php如何将mongodb中的时间戳字段转换成日期时间格式输出并分组?

我存在mongodb中的是时间戳,但是我想分组排序输出的时候是时间格式,请问怎么弄?

网友回复

+
15
-

可以使用project进行加工处理,代码如下:

<?php
$manager = new MongoDB\Driver\Manager("mongodb://localhost:27017");

// 插入数据
$bulk = new MongoDB\Driver\BulkWrite;

$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 123, 'atime' => time()-1000000]);
$bulk->insert(['x' => 2, 'name' => 'google', 'scores' => 10, 'atime' => time()-200000]);
$bulk->insert(['x' => 2, 'name' => 'baidu', 'scores' => 11, 'atime' => time()-1231123]);
$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 200, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'bfw', 'scores' => 123, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'google', 'scores' => 10, 'atime' => time()]);
$bulk->insert(['x' => 2, 'name' => 'baidu', 'scores' => 11, 'atime' => time()]);
$bulk->inser...

点击查看剩余70%

我知道答案,我要回答