Find data for specific date in mongodb

Question

I wanted to find data for 2014-08-01 from MongoDB collection. Date in MongoDB is in ISO format.I wrote below query, but it gives me very huge number which i suspect is not the data for 1 day. Can some one let me know what is wrong with query. sd is the key

db.history.count({sd:{$gte: new Date("2014-08-01")},sd:{$lt:new Date("2014-08-01")}})

Neil Lunn · Accepted Answer · 2014-08-20 02:21:40Z

10

Ranges can be specified using $gte and $lt in the same document portion:

db.history.count({ "sd": {
    "$gte": new Date("2014-08-01"), "$lt": new Date("2014-08-02")
}})

Otherwise the argument are considered to be separate and a logical "and" condition. But really since you are using the same "key" in your "sd" field, this is not allowed in a JSON/BSON document and violates the "unique" keys rule for hash structures in general. So one condition overwrites the other and only one is applied.

That is why your result is wrong. Use as shown above instead.

answered Aug 20, 2014 at 2:21

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Neil Over a year ago

Ofcourse it would violate unique key rule. Not sure how did i miss that. Thanks :)

Arul Over a year ago

@Neil I am having data for one month, I need to fetch maximum data for a specific date. ex: I need to fetch the maximum value for o5-Jan-2020 00:00:00 between 05-Jan-20200 23:59:59. How to achieve this condition

Afeesudheen · Accepted Answer · 2020-07-02 13:45:56Z

0

await model.find(
  {
    $or:
   [
     {
       createdDate:
      { $gte: new Date(startDate), $lte: new Date(endDate) },
     },
     {
       createdDate:
      { $gte: new Date(startDate), $lte: new Date(endDate).setDate(new Date(endDate).getDate() + 1) },
     },
   ],
  },
)

Please assign value to startDate and endDate. The above example will help to find different data from different date as well as the same date for example if your trying to fetch data from '2020-06-22' to '2020-07-02' you will get data from this date range, other your are trying to fetch data on the same date this code will work that mechanism also

Thank you

answered Jul 2, 2020 at 13:45

Afeesudheen

1,0342 gold badges14 silver badges21 bronze badges

Collectives™ on Stack Overflow

Find data for specific date in mongodb

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related