mongodb query for date fields

Question

I save a mongodb field 'date' as datetime object and use following queries

1.db.test_collection.find({'date': {'$gte': start_date_time}})
2. db.test_collection.find({"date": {"$gte": start_date_time, "$lte": end_date_time}

where start_date_time is (say)2014-06-03 00:00:00 and end_date_time 2014-06-03 23:59:59 i insert some values to mongodb, But I don't give any results. please help me to solve the issue.

sample value in my db is datetime.datetime(2014, 6, 4, 3, 47, 25, 637000) — Jisson
– Jisson, Commented Jun 4, 2014 at 9:05
That isn't a document. You can actually edit your post to show what the document actually looks like. — Neil Lunn
– Neil Lunn, Commented Jun 4, 2014 at 9:07
@ Neil Lunn, thanks for your helping attitude. Actaully there was no error in my script> I used datetime.datetime.now() to save date to db, But apache time different from server time!. now I use datetime.datetime.utcnow(). The problem fixed — Jisson
– Jisson, Commented Jun 4, 2014 at 12:43

fmgonzalez · Accepted Answer · 2014-06-03 14:47:11Z

1

You should use the datetime type.

import datetime

db.test_collection.find({'date': {'$gte': datetime.datetime(2014, 6, 3, 16, 46) }})

You can see more in the documentation (http://api.mongodb.org/python/current/tutorial.html)

Hope it works fine for you!

answered Jun 3, 2014 at 14:47

fmgonzalez

8231 gold badge7 silver badges17 bronze badges

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

1 Comment

Jisson Over a year ago

start_date_time am using is a datetime object

Collectives™ on Stack Overflow

mongodb query for date fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related