How to insert datetime string into Mongodb as ISODate using pymongo

Question

How to insert datetime string like this "2017-10-13T10:53:53.000Z" into mongo db as ISODate? I get a string in mongodb when I insert: datetime.strptime("2017-10-13T10:53:53.000Z", "%Y-%m-%dT%H:%M:%S.000Z")

Answer 1

This works for me:

from pymongo.mongo_client import MongoClient import datetime  d = datetime.datetime.strptime("2017-10-13T10:53:53.000Z", "%Y-%m-%dT%H:%M:%S.000Z")  with MongoClient() as mongo:     db = mongo.get_database("test")     db['dates'].insert({"date" : d}) 

Check in mongo:

> use test switched to db test > db.dates.findOne() {     "_id" : ObjectId("589307d7cfd6c908d4b677d6"),     "date" : ISODate("2017-10-13T10:53:53Z") } 

UPDATE: As commented, if you get a "time data does not match format" error, try a more general format string such as: %Y-%m-%dT%H:%M:%S.%fZ