關(guān)于MongoDB中的時間戳

> db.foo.find()
{ "_id" : ObjectId("5a7140013469a2e6d90d528a"), "created_at" : 1512057733000 }

> db.foo.aggregate(
... {$project:{created_at:{"$add": [ new Date(0), "$created_at" ]}}}
... )
{ "_id" : ObjectId("5a7140013469a2e6d90d528a"), "created_at" : ISODate("2017-11-30T16:02:13Z") }

但是同樣的時間戳在Mysql中卻又不同了

>select from_unixtime(1512057733);
+---------------------------+
| from_unixtime(1512057733) |
+---------------------------+
| 2017-12-01 00:02:13       |
+---------------------------+

到底哪個更準呢？