Skip to content

Instantly share code, notes, and snippets.

@jiangzhuo
Last active August 29, 2015 14:07
Show Gist options
  • Save jiangzhuo/922ae75061a5c0c39779 to your computer and use it in GitHub Desktop.
Save jiangzhuo/922ae75061a5c0c39779 to your computer and use it in GitHub Desktop.
// This function returns an ObjectId embedded with a given datetime
// Accepts both Date object and string input
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
}
// Find all documents created after midnight on May 25th, 1980
db.mycollection.find({ _id: { $gt: objectIdWithTimestamp('1980/05/25') } });
@jiangzhuo
Copy link
Author

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