在MongoDB中从ISODate获取月，日，年等？
让我们创建一个包含文档的集合-
> db.demo548.insertOne({"dueDate":new ISODate("2020-04-09 12:12:40")});{
"acknowledged" : true,
"insertedId" : ObjectId("5e8e30499e5f92834d7f05de")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo548.find();
这将产生以下输出-
{ "_id" : ObjectId("5e8e30499e5f92834d7f05de"), "dueDate" : ISODate("2020-04-
09T12:12:40Z") }以下是从ISODate显示，月，日，周，年等的查询-
> db.demo548.aggregate( [ { $project: { Year: { $year: "$dueDate"
}, Month: { $month: "$dueDate" }, Day: { $dayOfMonth: "$dueDate"
}, Hour: { $hour: "$dueDate" }, Minutes: { $minute: "$dueDate" },
Seconds: { $second: "$dueDate" }, Milliseconds: { $millisecond: "$dueDate" },
DayOfYear: { $dayOfYear: "$dueDate" }, DayOfWeek: { $dayOfWeek: "$dueDate"
}, Week: { $week: "$dueDate" } } } ] ).pretty();这将产生以下输出-
{
"_id" : ObjectId("5e8e30499e5f92834d7f05de"),
"Year" : 2020,
"Month" : 4,
"Day" : 9,
"Hour" : 12,
"Minutes" : 12,
"Seconds" : 40,
"Milliseconds" : 0,
"DayOfYear" : 100,
"DayOfWeek" : 5,
"Week" : 14
}热门推荐
10 八一幼儿祝福语大全简短
11 公司乔迁食堂祝福语简短
12 婚礼结束聚餐祝福语简短
13 儿媳买车妈妈祝福语简短
14 毕业送礼老师祝福语简短
15 同事辞职正常祝福语简短
16 恭贺新婚文案祝福语简短
17 金店立秋祝福语简短英文
18 婆婆高寿祝福语大全简短