I have a collection that I need to export every 5 minutes based on the timestamp field.
When querying the collection, the maximum date is as follows:
db.testcol.find({},{_id : 0,ts : 1}).sort({ts:-1})
2017-04-14 23:40:27.690Z
I converted it to milliseconds: 1492213227000
ex: max1=db.testcol.find({},{_id : 0,ts : 1}).sort({ts:-1})
print (new Date(max1).getTime());
Now, when querying the collection, there should not be any rows with timestamps greater than 1492213227000.
ex: db.testcol.find({ts:{$gt:new Date(1492213227000)}},{_id : 0,ts : 1})
However, despite this query, the same value is still being seen.
2017-04-14 23:40:27.690Z
If you could provide assistance in resolving this issue, it would be greatly appreciated.
Thank you, Ashwin