如何从 mongoDb 过滤过去 10 天的记录? [英] how to filter last 10 days records from mongoDb?

问题描述

var require = require('moment');
var today = new Date();
var dd = today.getDate();
var mm = today.getMonth()+1; //January is 0!

var yyyy = today.getFullYear();

if(dd<10) {
  dd='0'+dd
} 

if(mm<10) {   
  mm='0'+mm
} 

today = yyyy+'/'+mm+'/'+dd;
console.log(today);
videofiles.find({date:{$lte:'today'}}

上面提到的是我的代码..下面是我的 Db 值..我不知道如何从 mongodb 过滤过去 10 天的记录.我已经提到过滤日期的值小于或等于今天，但我真的需要过滤过去 10 天的记录，我是 mongo db 的新手，node.js videofiles 指的是我在 mongodb 中的收藏.

Above mention is my code ..The below is my Db values..i do no how to filter last 10 days records from mongodb. I have mentioned the value of filter date as lesser than or equal to today but i really need to filter last 10 days of records and i am new to mongo db and node.js videofiles refers to the name of my collection in mongodb.

"date": "2017/03/10",
"is_deleted": 0,
"filemimeType": "audio/mp3",
"emotionCount": 0,
"originalname": "1489042167918-1489040146195-SampleAudio_0.5mb (1).mp3",
"updatedAt": "2017-03-10T05:54:34.032Z",
"isUserLiked": 0,
"country": "India",
"fileuploadFilename": "1489125273974-1489042167918-1489040146195-SampleAudio_0.5mb (1).mp3",
"_id": "58c23f9a180ac54d758b5fc0",
"likeCount": 0,
"viewed": 0

推荐答案

添加以下代码:

today.setDate(today.getDate() - 10);

在这一行之后:

var today = new Date();

然后替换您的代码行:

videofiles.find({date:{$lte:'today'}}

用这一行:

db.videofiles.find({"date":{"$gte":'today'}})

这篇关于如何从 mongoDb 过滤过去 10 天的记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！