MongoDb find collection document based on timestamp

Question

I have user profile data as:

 {u'DOB': None, u'_id': ObjectId('5906f3b.....'), u'active': 0, u'bfunc': 0, u'city': None, u'contact': u'',

u'created': 1493627839,

 u'email': u'[email protected] u'facebook_id': u'', u'fburl': None, u'firstname': u'', u'gender': None, u'group_id': None}

I want to find all data between last 4 hrs based on created field.

Current created value is 1493627839 which is 2017-05-01 14:07:19

I want to find lessthan current time and greaterthan last 4 hrs. How could i find value based on datetime.

Should i convert current time into timestamp then find or something else?

I did this but it returned 0 as my values stored in timestamp format.

 value = [] cursor = collection.find({ 'created': { "$gte": datetime.datetime.now(), "$lt": datetime.datetime.now() - datetime.timedelta(days=5) } })

how could i query it.

Note: I am storing values in php but this query is fired in 'python 2.7'.

Edit:

 value = [] cursor = collection.find({ 'created': { "$lt": datetime.datetime.now(), "$gte": datetime.datetime.now() - datetime.timedelta(days=5) } })

but still find query is empty

@Love-Kesh if value of datetime.datetime.now(), is 2017-05-01 14:07:19 then value of datetime.timedelta(days=5) 2017-04-30 17:00:25.097000 — Bablu
– Bablu, Commented May 5, 2017 at 11:31

Love-Kesh · Accepted Answer · 2017-05-05 11:48:26Z

1

You are using opposite condition , use as follow

timenow=datetime.datetime.now(); ltunix = timenow.strftime('%s'); //convert to timestamp gteTime= timenow- datetime.timedelta(hours=4); getTimeUnix=gteTime.strftime('%s'); //convert to timestamp cursor = collection.find({ 'created': { "$lt": ltunix, "$gte": getTimeUnix } })

edited May 5, 2017 at 11:48

answered May 5, 2017 at 11:30

Love-Kesh

8129 silver badges17 bronze badges

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

11 Comments

Bablu Over a year ago

thnkx for correction but it still showing nothing in find.

Love-Kesh Over a year ago

is your query working without any condition , like find() ?

Bablu Over a year ago

yes...it shows all values... I also copied output of find({}) up.

Love-Kesh Over a year ago

Now check for only $lt , then only $gte condition , and see output one by one. Also increase gte time difference like datetime.timedelta(days=5) for testing

Bablu Over a year ago

still empty list... [] checked both $lt and $gte

|

Collectives™ on Stack Overflow

MongoDb find collection document based on timestamp

1 Answer 1

11 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Linked

Related