KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a MongoDB datastore set up with location data stored like this: { "_id" : ObjectId("51d3e161ce87bb000792dc8d"), "datetime_recorded" : ISODate("2013-07-03T05:35:13Z"), "loc" : { "coordinates" : [ 0.297716, 18.050614 ], "type" : "Point" }, "vid" : "11111-22222-33333-44444" } I'd like to be able to perform a query similar to the date range example but instead on a time range . i.e. Retrieve all points recorded between 12AM and 4PM (can be done with 1200 and 1600 24 hour time as well). e.g. With points: "datetime_recorded" : ISODate("2013-05-01T12:35:13Z"), "datetime_recorded" : ISODate("2013-06-20T05:35:13Z"), "datetime_recorded" : ISODate("2013-01-17T07:35:13Z"), "datetime_recorded" : ISODate("2013-04-03T15:35:13Z"), a query db.points.find({'datetime_recorded': { $gte: Date(1200 hours), $lt: Date(1600 hours)} }); would yield only the first and last point. Is this possible? Or would I have to do it for every day?
Tags (comma-separated)
Save Edits
Cancel