JIYIK CN >

In this MongoDB article, the problems with returning queries based on dates are pointed out. In addition, it explains in detail how to query using date ranges in MongoDB.

Using date range queries in MongoDB

This section will show you how to write a MongoDB date range query to fetch records based on a timestamp. Examples of MongoDB date queries include MongoDB date is greater than or less than a time or date, etc.

grammar:

db.collection.find({
    day: {
        $gt: ISODate("2020-01-21"),
        $lt: ISODate("2020-01-24")
    }
})

This query returns all documents in the collection daywhere the field is greater than 2020-01-21and less than .2020-01-24

The instructions shown above are easy to understand. However, there are slight differences between these instructions.

You can use $gteto indicate this 大于或等于.

gte = greater than or equal to i.e >=

$gtexpress 大于.

gt  = greater than i.e >

$lteUsed for 小于或等于.

lte = less than or equal to i.e <=

$ltexpress 小于.

lt  = less than i.e <

The following information shows how to use this syntax in practice with collection data that has the following documents:

db.data.insertOne({day: new Date("2022-01-20"), amount: 40})
db.data.insertOne({day: new Date("2022-01-21"), amount: 32})
db.data.insertOne({day: new Date("2022-01-22"), amount: 19})
db.data.insertOne({day: new Date("2022-01-23"), amount: 29})
db.data.insertOne({day: new Date("2022-01-24"), amount: 35})

Find documents between two dates in MongoDB

You can use the following query to find dayall documents where the field is between two specific dates:

db.data.find({
    day: {
        $gt: ISODate("2020-01-21"),
        $lt: ISODate("2020-01-24")
    }
})

Output:

{ _id: ObjectId("618548bc7529c93ea0b41490"),
  day: 2020-01-22T00:00:00.000Z,
  amount: 19 }

{ _id: ObjectId("618548bc7529c93ea0b41491"),
  day: 2020-01-23T00:00:00.000Z,
  amount: 29 }

Find documents after a specific date in MongoDB

You can use the following query given below to find dayall documents where the field is after a specific date:

db.data.find({
    day: {
        $gt: ISODate("2020-01-22")
    }
})

Output:

{ _id: ObjectId("618548bc7529c93ea0b41491"),
  day: 2020-01-23T00:00:00.000Z,
  amount: 29 }

{ _id: ObjectId("618548bc7529c93ea0b41492"),
  day: 2020-01-24T00:00:00.000Z,
  amount: 35 }

Find documents before a specific date in MongoDB

You can use the following query given below to find dayall documents where the field is before a specific date:

db.data.find({
    day: {
        $lt: ISODate("2020-01-22")
    }
})

Output:

{ _id: ObjectId("618548bc7529c93ea0b4148e"),
  day: 2020-01-20T00:00:00.000Z,
  amount: 40 }

{ _id: ObjectId("618548bc7529c93ea0b4148f"),
  day: 2020-01-21T00:00:00.000Z,
  amount: 32 }

Returning Date-Based Queries in MongoDB

Let's look at an example of how to return a query based on a date in MongoDB.

Let us create a datacollection called with the document to grasp the concept better. Following is the query to build a collection containing records:

db.data.insertOne({"PassengerName":"John","PassengerAge":23,"PassengerArrivalTime":new ISODate("2018-03-10 14:45:56")});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8a57be9064dcd4a68b70e4")
}
db.data.insertOne({"PassengerName":"Larry","PassengerAge":21,"PassengerArrivalTime":new ISODate("2018-05-19 11:10:23")});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8a57bf9064dcd4a68b70e5")
}
db.data.insertOne({"PassengerName":"Mike","PassengerAge":24,"PassengerArrivalTime":new ISODate("2018-08-25 16:40:12")});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c8a57bf9064dcd4a68b70e6")
}
db.data.insertOne({"PassengerName":"Carol","PassengerAge":26,"PassengerArrivalTime":new ISODate("2019-01-29 09:45:10")});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c8a57bf9064dcd4a68b70e7")
}

This will find()display all the documents in the collection with the help of method. The query for this is as follows:

db.data queryFromDate.find().pretty();

Output:

This is a return query based on date. 2018-05-19T11:10:23ZRecords with dates after will be displayed as,

> db.data queryFromDate.find({"PassengerArrivalTime" : { $gte : new ISODate("2018-05-19T11:10:23Z") }}).pretty();

Output:

in conclusion

With the help of this article, you have gained Date()information about using the and commands. In addition, $gtethe and $ltecommands will be explained with examples.

The query based on date return is also illustrated with code snippets.