如何查询日期栏位的年份部分?
-
假设Orders集合的文档结构类似下面文档:
{
如何直接查询OrderedDate年份为2017的全部文档?
"OrderID":"P201704200001";
"CustomerID":"C000001";
"OrderedDate":ISODate("2017-04-20T08:12:34.567Z")
}
-
一個簡單的做法 設定整年作為 range
db.yyy.insert([{
"OrderID":"P201704200003",
"CustomerID":"C000003",
"OrderedDate":ISODate("2018-04-20T08:12:34.567Z"),
},{
"OrderID":"P201704200001",
"CustomerID":"C000001",
"OrderedDate":ISODate("2017-04-20T08:12:34.567Z")
},{
"OrderID":"P201704200002",
"CustomerID":"C000002",
"OrderedDate":ISODate("2016-04-20T08:12:34.567Z"),
}])
db.yyy.find({$and:[
{OrderedDate:{$gte: ISODate("2017-01-01T00:00:00.000Z")}},
{OrderedDate:{$lte: ISODate("2017-12-31T23:59:59.999Z")}}
]})