MongoDB – Querying between a time range of hours

by

Well, the best way to solve this is to store the minutes separately as well. But you can get around this with the aggregation framework, although that is not going to be very fast:

db.so.aggregate( [ 
    { $project: {
        loc: 1,
        vid: 1,
        datetime_recorded: 1, 
        minutes: { $add: [
            { $multiply: [ { $hour: '$datetime_recorded' }, 60 ] }, 
            { $minute: '$datetime_recorded' } 
        ] } 
    } },
    { $match: { 'minutes' : { $gte : 12 * 60, $lt : 16 * 60 } } }
] );

In the first step $project, we calculate the minutes from hour * 60 + min which we then match against in the second step: $match.

More Related Contents:

  1. Find objects between two dates MongoDB
  2. Can you specify a key for $addToSet in Mongo?
  3. Performing regex queries with PyMongo
  4. mongo – couldn’t connect to server 127.0.0.1:27017
  5. Query Mongodb on month, day, year… of a datetime
  6. Create an ISODate with pyMongo
  7. Remove multiple documents from mongo in a single query
  8. Display which day it is? sunday or monday “php coding”? [closed]
  9. How does MongoDB sort records when no sort order is specified?
  10. How to listen for changes to a MongoDB collection?
  11. Cascade style delete in Mongoose
  12. Find MongoDB records where array field is not empty
  13. In Python, how do you convert seconds since epoch to a `datetime` object?
  14. MongoDB – Update an object in nested Array
  15. How to import data from mongodb to pandas?
  16. Creating Multifield Indexes in Mongoose / MongoDB
  17. Mongodb Explain for Aggregation framework
  18. MongoDB aggregation comparison: group(), $group and MapReduce
  19. Multiple Counts with single query in mongodb
  20. In Ruby on Rails, what’s the difference between DateTime, Timestamp, Time and Date?
  21. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  22. Failed to start mongod.service: Unit mongod.service not found
  23. Convert to/from DateTime and Time in Ruby
  24. mongodb.conf bind_ip = 127.0.0.1 does not work but 0.0.0.0 works
  25. How to resolve MongoDB failing to instantiate [closed]
  26. What is a Cursor in MongoDB?
  27. How do I rename fields when performing search/projection in MongoDB?
  28. Update MongoDB collection using $toLower
  29. Aggregating hourly data into daily aggregates
  30. mongodb aggregation framework match by nested documents

Leave a Comment