5

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() }}

Can I write 

db.doc.find({'_id.getTimestamp().getTime()' : { $gte : ObjectId().getTimestamp().getTime() }}
Community
  • 1
  • 1
Praveen Singh Yadav
  • 1,743
  • 4
  • 19
  • 30

1 Answers1

9

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") }})

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") }})
Community
  • 1
  • 1
dersvenhesse
  • 6,015
  • 2
  • 28
  • 50
  • Thanks I used this,It worked for me db.sale.aggregate({ $match :{ firm :ObjectId("52e56c009dbc794999ea5c3d") } }, {$project : {day : {$dayOfMonth : '$date'},items :1,patient :1}}, {$match : {day: {$gte : new Date().getDate()}}}, {$unwind : "$items"}, {$group :{_id:"$_id" ,count :{$sum:1},patient:"$patient"} }) – Praveen Singh Yadav Jan 30 '14 at 21:05