How to insert datetime string into Mongodb as ISODate using pymongo

python pymongo
ArchieTiger picture ArchieTiger · Feb 2, 2017 · Viewed 28.5k times · Source

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

jas picture jas · Feb 2, 2017

This works for me, do you get a different result?

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

Related questions

JSON ValueError: Expecting property name: line 1 column 2 (char 1)

I am having trouble using json.loads to convert to a dict object and I can't figure out what I'm doing wrong.The exact error I get running this is ValueError: Expecting property name: line 1 column 2 (char 1) Here is my …

Read More
How to sort mongodb with pymongo

I'm trying to use the sort feature when querying my mongoDB, but it is failing. The same query works in the MongoDB console but not here. Code is as follows: import pymongo from pymongo import Connection connection = Connection() db = connection.…

Read More
How to update values using pymongo?

I've a mongodb collection in this form: {id=ObjectId(....),key={dictionary of values}} where dictionary of values is {'a':'1','b':'2'.....} Let dictionary of values be 'd'. I need to update the values of the key in …

Read More