How to query documents by Date in MongoDB?

Question

My events colleciton stores the following documents:

{
  "_id": {
      "$oid": "537b2a232a47f21830ae5b7b"
  },
  "startTime": {
      "$date": "2014-05-18T21:00:00.000Z"
  },
  "endTime": {
      "$date": "2014-05-18T23:00:00.000Z"
  }
},
{
  "_id": {
    "$oid": "537af8136c4162d0379e2139"
  },
  "startTime": {
    "$date": "2014-05-19T20:30:00.000Z"
  },
  "endTime": {
    "$date": "2014-05-19T21:30:00.000Z"
  }
}

How could I query events by specific startTime in like the following:

var startTime = '2014-05-18T20:00:00.000Z';

db.collection.find({startTime: {$eq: startTime}});

My problem is I need ignore time and use only date in the query. How could I construct my query?

Bruno Freitas · Accepted Answer · 2016-12-21 17:51:17Z

11

Define a date at midnight of the day you want to query and at midnight of the following day. Then use the $lt (less-than) and $gt (greater-than) operators to get all results in the timespan between these two points in time.

var from = new Date('2014-05-18T20:00:00.000Z');
var to = new Date('2014-05-19T20:00:00.000Z');

db.collection.find({startTime: {$gt: from, $lt:to}});

edited Dec 21, 2016 at 17:51

Bruno Freitas

3431 gold badge4 silver badges13 bronze badges

answered May 26, 2014 at 6:33

Philipp

70.1k10 gold badges121 silver badges159 bronze badges

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

4 Comments

Erik Over a year ago

How could I create endTime based on startTime?

Philipp Over a year ago

@Erik You could increment the day of a date by using somedate.setDays(someDate.getDays() + 1). And yes, this works across month-boundaries. Trying to set the date to January 32nd sets it to February 1st. More about node.js and date manipulation in this blog article.

Erik Over a year ago

Thanks! and how could I ignore time?

Philipp Over a year ago

@Erik You can't. A Date object always represents a specific point in time, accurately to the millisecond. A day is a 24 hour time period. A time period is defined by a start-date and an end-date. When you want to select all dates in a given 24 hour time period, you need to query all dates larger than the beginning and less than the end of that time period.

Abs · Accepted Answer · 2014-05-26 06:30:06Z

0

You need to create Date objects this should help

var start = new Date(2010, 3, 1);
var end = new Date(2010, 4, 1);

http://cookbook.mongodb.org/patterns/date_range/

answered May 26, 2014 at 6:30

Abs

3,9621 gold badge33 silver badges30 bronze badges

4 Comments

Erik Over a year ago

But I have only startTime.

Abs Over a year ago

db.collection.find({startTime: {$eq: new Date("2014-05-19T20:30:00.000Z")}});

Erik Over a year ago

I get the following error: "Can't use $eq with Date."

Abs Over a year ago

try it like this db.collection.find({"createdAt" : new Date("2014-05-19T20:30:00.000Z") }); from here stackoverflow.com/questions/8835757/return-query-based-on-date

Arthur Ronconi · Accepted Answer · 2023-07-08 13:12:39Z

0

You can store a number in a field with a inverted date. So, for a date like 2023-06-08 you should store the number 20230608. This way, you can search using the following query:

db.collection.find({ startTime: 20230608 })

This method is much easier than using dates and improves database performance.

answered Jul 8, 2023 at 13:12

Arthur Ronconi

2,43828 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to query documents by Date in MongoDB?

3 Answers 3

4 Comments

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related