How to get a document for a particular timestamp in Mongodb?

Question

I have the following set of document info in my collection and how to get one document with a particular timestamp?

As this timestamp is in ISODate(), how to pass the same from my pyMongodb client?

[ { "_id" : ObjectId("5f64658a64b79fed80b8e4df"), "time" : ISODate("2020-09-18T13:15:14.290Z"), "details" : "with all details", "type" : "general", "payLoad" : { "myname" : "nameofme", } }, { "_id" : ObjectId("5f64658a64b79fed80b8e4df"), "time" : ISODate("2020-09-18T13:18:20.290Z"), "details" : "with all details", "type" : "general", "payLoad" : { "myname" : "nameofme", } }, { "_id" : ObjectId("5f64658a64b79fed80b8e4df"), "time" : ISODate("2020-09-18T13:50:20.290Z"), "details" : "with all details", "type" : "general", "payLoad" : { "myname" : "nameofme", } } ]

Belly Buster · Accepted Answer · 2020-09-19 07:19:00Z

Construct it using a datetime object:

from datetime import datetime from pymongo import MongoClient db = MongoClient()['mydatabase'] dt = datetime(2020, 9, 18, 13, 15, 14, 290000) print(list(db.mycollection.find({"time" : dt})))

gives:

[{'_id': ObjectId('5f64658a64b79fed80b8e4dd'), 'time': datetime.datetime(2020, 9, 18, 13, 15, 14, 290000), 'details': 'with all details', 'type': 'general', 'payLoad': {'myname': 'nameofme'}}]

Collectives™ on Stack Overflow

How to get a document for a particular timestamp in Mongodb?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related