Query mongo on timestamp

Question

I want to query Mongo based on timestamp. Follwing is the field in mongo.

"timestamp" : "2016-03-07 11:33:48"

Books is the collection name and below is my query for time period of 1 minute:

db.Books.find({"timestamp":{$gte: ISODate("2016-03-07T11:33:48.000Z"), $lt: ISODate("2016-03-07T11:34:48.000Z")}})

Also is there any alternative like I don't have to give greater and lower limit on timestamp. But query based time interval mentioned. Something like, if present timestamp is TS = "2016-03-07T11:33:48.000Z" then query should be between TS and TS + 1 minute rather than explicitly mentioning timestamp. Something like adding 1 minute to present timestamp

dsl1990 · Accepted Answer · 2016-03-27 03:18:38Z

13

db.Books.find({"timestamp":{$gte: "2016-03-07 11:33:48", $lt: "2016-03-07 11:34:48"}})

ISODate is not required here

answered Mar 27, 2016 at 3:18

dsl1990

1,2195 gold badges15 silver badges25 bronze badges

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

Comments

Edward Tan · Accepted Answer · 2023-04-05 17:11:55Z

2

If someone is searching for how to do this using the MongoDB Atlas GUI's Collections tab interface, this is what one would do. One can put this query string in the "Filter" UI and hit Apply:

Assuming there's a timestamp field named "modified_time" of type "Date" in the schema, one would need to use this as the Filter input:

{ modified_time: {$gt: ISODate('2023-01-01')} }

Note that use "Date" instead of "ISODate" will not work in this case. And doing it without the ISODate() also will not work unlike the other answer, which is when doing it programmatically.

answered Apr 5, 2023 at 17:11

Edward Tan

9749 silver badges18 bronze badges

Collectives™ on Stack Overflow

Query mongo on timestamp

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related