blocks|key|2321235|text|这是因为您正在查询的日期字段是一个字符串字段，而不是日期()。在您的mongo文档中，将javascript日期对象插入到日期字段中，而不是自定义日期字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2321236|喜欢|2321237|{+deviceID:+186,,"date":+new+Date(2012,+7,+14)+}|code-block|syntax|javascript|2321238|在执行remove时，如下所示|2321239|db.coll.remove({date:{$lte:new+Date(2012,+7,+14)}})|2321240|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Its because the date field you are querying on is a string filed and not a Date(). In your mongo documents instead of a custom date string, insert javascript date objects into date field.

like 

<pre><code>{ deviceID: 186,,"date": new Date(2012, 7, 14) }
</code></pre>

and when you execute the remove do it like

<pre><code>db.coll.remove({date:{$lte:new Date(2012, 7, 14)}})
</code></pre>

blocks|key|5849986|text|这是因为您正在以错误的格式存储数据。你有一个字符串，字符串'15'比字符串'5'小。将开头的字符串转换为日期(请阅读here如何在mongo中使用日期)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5849987|只有你才能用它来正确地比较你的日期：|5849988|db.coll.remove({
++date:{
++++$lte+:+new+Date(2012,+7,+14)
++}
})|code-block|syntax|javascript|5849989|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.mongodb.org/manual/core/shell-types/#date^0|T|4|11|3|1M|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|13|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

This is because you are storing your data in a wrong format. You have a string an string
<code>'15'</code> is smaller than string <code>'5'</code>. Convert your strings in the beginning to date (read <a href="http://docs.mongodb.org/manual/core/shell-types/#date" rel="nofollow">here</a> how to use dates in mongo).

And only than you can use it to properly compare your dates: 

<pre><code>db.coll.remove({
 date:{
 $lte : new Date(2012, 7, 14)
 }
})
</code></pre>

blocks|key|1778331|text|这是因为您的日期是字符串。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1778332|因此，在比较字符串"2014-3-5“时，在词汇意义上，大于"2014-3-15"，因为要比较的是"1”小于"5“。|1778333|将您的日期设置为真正的ISO日期，否则您将永远遇到此问题。|1778334|像这样批量转换，假设格式为“年”“月”“日”：|1778335|db.eval(function(){

+++db.collection.find().forEach(function(doc)+{
+++++++var+d+=+doc.date.split("-");
+++++++var+date+=+new+Date(+
+++++++++++""+%2B+d[0]+%2B+"-"+%2B
++++++++++(+d[1]+<=+9+)+?+"0"+%2B+d[1]+:+d[1]+%2B+"-"+%2B
++++++++++(+d[2]+<=+9+)+?+"0"+%2B+d[2]+:+d[2]
+++++++);
+++++++db.collection.update(
+++++++++++{+"_id":+doc._id+},
+++++++++++{+"$set":+{+"date":+date+}
+++++++);
+++});
})|code-block|syntax|javascript|1778336|这将确保您在转换时获得正确的日期。|1778337|entityMap^0|9|3|0|S|U|0|0|T|0|0|N|0|0|0|H|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|L|3|M|5|N|7|16|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|6|7|17|8|@$9|18|A|19|B|C]]|D|@]|E|$]]|$1|S|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|T|$]]

The reason for this is is your dates are strings.

So in a lexical sense when comparing strings "2014-3-5" is greater than "2014-3-15", as what is being compared is that "1" is less than "5".

Fix your dates as real ISO Dates, or you will forever have this problem.

Batch convert like this, assuming "year" "month" "day" in format:

<pre class="lang-js prettyprint-override"><code>db.eval(function(){

 db.collection.find().forEach(function(doc) {
 var d = doc.date.split("-");
 var date = new Date( 
 "" + d[0] + "-" +
 ( d[1] &lt;= 9 ) ? "0" + d[1] : d[1] + "-" +
 ( d[2] &lt;= 9 ) ? "0" + d[2] : d[2]
 );
 db.collection.update(
 { "_id": doc._id },
 { "$set": { "date": date }
 );
 });
})
</code></pre>

That makes sure you get the right dates on conversion.

blocks|key|1778358|text|如果要从MongoDB中删除早于指定日期的数据，则必须确保该日期。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1778359|要检查输入的格式是否正确，最简单的方法是在查询中使用它之前对其进行测试。|1778360|例如，如果您想在Mongo+shell中获取ISODate格式的当前日期，只需输入new+Date，您就会获得Mongo格式的当前日期。|offset|length|style|CODE|1778361|我已经在Mongo+shell中尝试了以下内容：|1778362|new+Date(2017,+11,+1)|code-block|syntax|javascript|1778363|然后它会返回|1778364|ISODate("2017-11-30T16:00:00Z")|1778365|这不是我想要的。|1778366|我想要的是在2017年11月1日之前删除数据。|1778367|以下是对我有效的方法：|1778368|new+Date("2017-11-01")|1778369|然后返回：|1778370|ISODate("2017-11-01T00:00:00Z")|1778371|这就是我想要的。|1778372|entityMap^0|0|0|15|8|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1C|8|@$F|1D|G|1E|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1F|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1G|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|1I|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|1J|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1L|8|@]|9|@]|A|$]]|$1|10|3|11|5|N|7|1M|8|@]|9|@]|A|$O|P]]|$1|12|3|13|5|6|7|1N|8|@]|9|@]|A|$]]|$1|14|3|15|5|N|7|1O|8|@]|9|@]|A|$O|P]]|$1|16|3|17|5|6|7|1P|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|1Q|8|@]|9|@]|A|$]]]|19|$]]

If you want to remove data from MongoDB from the date less than specified, you MUST make sure of the date.

Easiest way for you to check whether you are inputting the right format is to test it before you use it in your query.

For example if you want to get current date in ISODate in Mongo shell, just type <code>new Date</code> and you will get the current date in Mongo.

I've tried the following in the Mongo shell:

<pre><code>new Date(2017, 11, 1)
</code></pre>

and it returns

<pre><code>ISODate("2017-11-30T16:00:00Z")
</code></pre>

which is not what I wanted.

What I want is to delete data before 1 November 2017.

Here's what works for me:

<pre><code>new Date("2017-11-01")
</code></pre>

and it returns:

<pre><code>ISODate("2017-11-01T00:00:00Z")
</code></pre>

Which is what I wanted.

I have the following data.

<pre><code>{
 deviceID: 186,
 date: "2014-3-15"
}
{
 deviceID: 186,
 date: "2014-3-14"
}
{
 deviceID: 186,
 date: "2014-3-13"
}
</code></pre>

And some lower dates, like <code>2014-3-9 , 8 ,7 ,6</code> etc.

When doing a <code>db.coll.remove({date:{$lte:"2014-3-5"}})</code>

Mongo removes the <code>15,14,13</code> aswell, but keeps single digit day dates. Is this maybe due to the date is a string?

I dont know how else to format the date so I can remove all dates below a certain date.

It is supposed to be a cleaning process, removing all documents with a date lower than specified.

mongodb remove all dates less than specified

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有以下数据。{    deviceID: 186,    date: "2014-3-15"}{    deviceID: 186,    date: "2014-3-14"}{    deviceID: 186,    date: "2014-3-13"}以及一些较低的日期，如2014-3-9 , 8 ,7 ,6等...

问mongodb删除所有早于指定日期的日期
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mongodb删除所有早于指定日期的日期EN