查询 mongodb 返回今天创建的文档 [英] Query mongodb to return documents created today

问题描述

我如何编写过滤器来过滤今天创建的结果文档.我知道 ObjectId 有时间戳.我试过这个:

how can I write filter which results docs created today.I know ObjectId has timestamp. I tried this :

db.doc.find({_id : { $gte : ObjectId().getTimestamp().getTime() }}

我可以写吗

db.doc.find({'_id.getTimestamp().getTime()' : { $gte : ObjectId().getTimestamp().getTime() }}

推荐答案

尝试以下(基于此回答).这将返回自给定日期以来创建的所有文档.所以它也涵盖了今天的条目.

Try the following (based on this answer). This returns all documents created since the given date. So it covers todays entries as well.

db.doc.find({_id : { $gt : ObjectId(Math.floor(new Date('2014/01/30')/1000).toString(16)+"0000000000000000") }})

如果你不喜欢将日期作为字符串输入，你可以通过 Objects 创建它，但它会变得有点难看:

If you don't like to enter the date as string, you can create it via Objects, but it gets a little bit ugly:

db.doc.find({_id : { $gt : ObjectId(Math.floor(new Date(new Date().getFullYear()+'/'+(new Date().getMonth()+1)+'/'+new Date().getDate())/1000).toString(16)+"0000000000000000") }})

这篇关于查询 mongodb 返回今天创建的文档的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！