如何获取大于特定日期创建的所有 mongo 数据? [英] How do I fetch all mongo data which is created greater than a particular date?

问题描述

我读到必须使用 $gt 属性.无法解决这个问题.假设我有一些这样的 mongo 数据:

I read the $gt attribute has to be used. Not able to get around this. Let's say I have some mongo data like this:

{
    "startTime" : "Sun 25 Jan 2015 07:14:26 GMT",
    "endTime" : "",
    "jobStatus" : "JOBCANCELLED",
    "uiState" : "HISTORY",
    "priority" : "SILVER"
}

这就是我在 Mongo 中保存我的开始时间的方式.如果我想获取所有开始时间大于今天的作业的状态，我该怎么做?

That's how my start time is saved in my Mongo. If I want to get the statuses of all jobs which have the start time greater than today, How do I do it?

db.getCollection('jobsCollection').find({"startTime":{$gt: "What here?"})

推荐答案

首先，您需要将 startTime 从 String 格式转换为日期时间格式.

First you need to convert your startTime from String format to date time format.

从 mongo shell 开始:

To do from mongo shell :

 db.jobsCollection.find().forEach(function(doc){doc.startTime = new Date(doc.startTime);db.jobsCollection.save(doc)});

然后您可以编写大于日期的查询:

And then you can write the query for greater than date :

db.jobsCollection.find({"startTime":{$gt: new Date("2014-02-10")});

如果您遇到任何问题，请告诉我.

Let me know if you face any issue.

这篇关于如何获取大于特定日期创建的所有 mongo 数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！