Linked Questions

Popular Questions

Count records according to the difference of two dates in Mongodb

Asked by At

Based on the documents below, I need to count the records that the difference between the inicial_date and end_date is greater than and less than 5 minutes and the name = A.

[{
    "_id": 1,
    "name": "A",
    "inicial_date": "2019-01-01 12:00:00",
    "end_date": "2019-01-01 12:01:00"
},{
    "_id": 2,
    "name": "A",
    "inicial_date": "2019-01-01 12:05:00",
    "end_date": "2019-01-01 12:07:00"
},{
    "_id": 3,
    "name": "A",
    "inicial_date": "2019-01-01 12:00:00",
    "end_date": "2019-01-01 12:06:00"
},{
    "_id": 4,
    "name": "A",
    "inicial_date": "2019-01-01 12:04:00",
    "end_date": "2019-01-01 12:05:00"
},
    "_id": 5,
    "name": "A",
    "inicial_date": "2019-01-01 12:10:00",
    "end_date": "2019-01-01 12:20:00"
},{
    "_id": 6,
    "name": "A",
    "inicial_date": "2019-01-01 12:00:00",
    "end_date": "2019-01-01 12:08:00"
},{
    "_id": 7,
    "name": "A",
    "inicial_date": "2019-01-01 13:00:00",
    "end_date": "2019-01-01 13:01:00"
},{
    "_id": 8,
    "name": "B",
    "inicial_date": "2019-01-01 14:00:00",
    "end_date": "2019-01-01 14:09:00"
}]

The expected result:

{
    "less_than_5": 4,
    "greater_than_5": 3
}

Related Questions