Query Mongodb on specific or range month without year of a datetime

Question

I'm using mongodb to store datetime.

example

DB data:

[
{
  id: 1
  date: '2014-11-01T00:00:00.000Z'
},
{
  id: 2
  date: '2013-10-11T00:00:00.000Z'
},
{
  id: 3
  date: '2012-11-21T00:00:00.000Z'
}
]

filter by month 11, like query.find({'date': {$month: 11}}) should get result:

[
{
  id: 1
  date: '2014-11-01T00:00:00.000Z'
},
{
  id: 3
  date: '2012-11-21T00:00:00.000Z'
}
]

How to do that query to get what I want?

I search and got Query Mongodb on month, day, year... of a datetime, but it's not that I want, I don't want to filter the year of date.

Are your `date` values strings (like you show) or BSON Dates? — JohnnyHK, Oct 31 '14 at 17:13

score 4 · Accepted Answer · answered Oct 31 '14 at 18:13

4

$month is an aggregation operator, so it can only be used with aggregate, not find:

db.test.aggregate([
    {$project: {
        id: 1,
        date: 1,
        month: {$month: '$date'}
    }},
    {$match: {month: 11}},
    {$project: {
        id: 1,
        date: 1
    }}
])

Result:

{
    "result" : [ 
        {
            "_id" : ObjectId("5453d0b73712b66352662484"),
            "id" : 1,
            "date" : ISODate("2014-11-01T00:00:00.000Z")
        }, 
        {
            "_id" : ObjectId("5453d0b73712b66352662486"),
            "id" : 3,
            "date" : ISODate("2012-11-21T00:00:00.000Z")
        }
    ],
    "ok" : 1
}

answered Oct 31 '14 at 18:13

JohnnyHK

305,182
66
621
471

great, but your way need to know what's the name of all fields. Have the way to do that if I don't know fields name? – Zack Yang Oct 31 '14 at 18:21
Sort of, you can put `doc: $$ROOT` in your initial `$project` instead of the individual fields. – JohnnyHK Oct 31 '14 at 18:26
This could take ages if I have 5 milion records to $project. The match should be a first step. – Max Podriezov Dec 16 '19 at 10:18

Query Mongodb on specific or range month without year of a datetime

1 Answers1