我可以按日期查询 MongoDB ObjectId 吗? [英] Can I query MongoDB ObjectId by date?

问题描述

我知道 ObjectId 包含它们的创建日期.有没有办法查询ObjectId的这个方面?

I know that ObjectIds contain the date they were created on. Is there a way to query this aspect of the ObjectId?

推荐答案

将时间戳放入 ObjectIds 详细介绍了基于嵌入在 ObjectId 中的日期的查询.

Popping Timestamps into ObjectIds covers queries based on dates embedded in the ObjectId in great detail.

JavaScript 代码简述:

Briefly in JavaScript code:

/* 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') } });

这篇关于我可以按日期查询 MongoDB ObjectId 吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！