Skip to content

Instantly share code, notes, and snippets.

@jasonbartz
Created June 7, 2013 15:46
Show Gist options
  • Save jasonbartz/5730246 to your computer and use it in GitHub Desktop.
Save jasonbartz/5730246 to your computer and use it in GitHub Desktop.
Query mongodb by date via CLI, so I don't forget. Via http://stackoverflow.com/questions/8749971/can-i-query-mongodb-objectid-by-date
function objectIdWithTimestamp(timestamp) {
// Convert string date to Date object (otherwise assume timestamp is a date)
if (typeof(timestamp) == 'string') {
timestamp = new Date(timestamp);
}
// Convert date object to hex seconds since Unix epoch
var hexSeconds = Math.floor(timestamp/1000).toString(16);
// Create an ObjectId with that hex timestamp
var constructedObjectId = ObjectId(hexSeconds + "0000000000000000");
return constructedObjectId
}
@jasonbartz
Copy link
Author

// Find all documents created after midnight on May 25th, 1980

db.mycollection.find({ _id: { $gt: objectIdWithTimestamp('1980/05/25') } });

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment