blocks|key|199917|text|只需对@JohnnyHK的答案稍作修改|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199918|collection.find().sort({datefield:+-1},+function(err,+cursor){...});|code-block|syntax|javascript|199919|在许多用例中，我们希望返回最新的记录(比如最新的更新/插入)。|199920|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Just a slight modification to @JohnnyHK answer

<pre><code>collection.find().sort({datefield: -1}, function(err, cursor){...});
</code></pre>

In many use cases we wish to have latest records to be returned (like for latest updates / inserts).

blocks|key|200132|text|db.getCollection('').find({}).sort({_id:-1})+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|200133|这将根据插入日期按降序对集合进行排序|unstyled|200134|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>db.getCollection('').find({}).sort({_id:-1}) 
</code></pre>

This will sort your collection in descending order based on the date of insertion

blocks|key|199866|text|按日期排序不需要任何特殊的东西。只需按集合中所需的日期字段排序即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199867|针对1.4.28+node.js本机驱动程序进行了更新，您可以使用以下任一方法在datefield上进行升序排序：|offset|length|style|CODE|199868|collection.find().sort({datefield:+1}).toArray(function(err,+docs)+{...});
collection.find().sort('datefield',+1).toArray(function(err,+docs)+{...});
collection.find().sort([['datefield',+1]]).toArray(function(err,+docs)+{...});
collection.find({},+{sort:+{datefield:+1}}).toArray(function(err,+docs)+{...});
collection.find({},+{sort:+[['datefield',+1]]}).toArray(function(err,+docs)+{...});|code-block|syntax|javascript|199869|也可以使用'asc'或'ascending'来代替1。|199870|要降序排序，请使用'desc'、'descending'或-1代替1。|199871|entityMap^0|0|14|9|0|0|5|5|B|B|P|1|0|9|6|G|C|T|2|X|1|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@$D|Y|E|Z|F|G]|$D|10|E|11|F|G]|$D|12|E|13|F|G]]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@$D|15|E|16|F|G]|$D|17|E|18|F|G]|$D|19|E|1A|F|G]|$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|R|$]]

Sorting by date doesn't require anything special. Just sort by the desired date field of the collection.

Updated for the 1.4.28 node.js native driver, you can sort ascending on <code>datefield</code> using any of the following ways:

<pre><code>collection.find().sort({datefield: 1}).toArray(function(err, docs) {...});
collection.find().sort('datefield', 1).toArray(function(err, docs) {...});
collection.find().sort([['datefield', 1]]).toArray(function(err, docs) {...});
collection.find({}, {sort: {datefield: 1}}).toArray(function(err, docs) {...});
collection.find({}, {sort: [['datefield', 1]]}).toArray(function(err, docs) {...});
</code></pre>

<code>'asc'</code> or <code>'ascending'</code> can also be used in place of the <code>1</code>.

To sort descending, use <code>'desc'</code>, <code>'descending'</code>, or <code>-1</code> in place of the <code>1</code>.

blocks|key|199954|text|Sushant+Gupta的答案有点过时，不再有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199955|下面的代码片段现在应该是这样的：|199956|collection.find({},+{"sort"+:+['datefield',+'asc']}+).toArray(function(err,docs)+{});|offset|length|style|CODE|199957|entityMap^0|0|0|0|2D|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@$F|O|G|P|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Sushant Gupta's answers are a tad bit outdated and don't work anymore.

The following snippet should be like this now :

<code>collection.find({}, {"sort" : ['datefield', 'asc']} ).toArray(function(err,docs) {});</code>

blocks|key|199981|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199982|collection.find({},+{"sort"+:+[['datefield',+'asc']]},+function+(err,+docs)+{+...+});|code-block|syntax|javascript|199983|使用Node.js、Express.js和Monk|199984|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This worked for me:

<pre><code>collection.find({}, {"sort" : [['datefield', 'asc']]}, function (err, docs) { ... });
</code></pre>

Using Node.js, Express.js, and Monk

blocks|key|200111|text|collection.find().sort('date':1).exec(function(err,+doc)+{});|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|200112|这对我很有效|unstyled|200113|引用的https://docs.mongodb.org/getting-started/node/query/|offset|length|200114|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.mongodb.org/getting-started/node/query/^0|0|0|3|1G|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|F|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

<pre><code>collection.find().sort('date':1).exec(function(err, doc) {});
</code></pre>

this worked for me

referred <a href="https://docs.mongodb.org/getting-started/node/query/" rel="nofollow noreferrer">https://docs.mongodb.org/getting-started/node/query/</a>

blocks|key|200094|text|对于mongoose，它很简单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|200095|collection.find().sort('-date').exec(function(err,+collectionItems)+{
++//+here's+your+code
})|code-block|syntax|javascript|200096|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

With mongoose it's as simple as:

<pre><code>collection.find().sort('-date').exec(function(err, collectionItems) {
 // here's your code
})
</code></pre>

blocks|key|418293|text|如果您的日期格式是这样的:+14/02/1989+->您可能会发现一些问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|418294|您需要像这样使用ISOdate：|418295|var+start_date+=+new+Date(2012,+07,+x,+x,+x);+|code-block|syntax|javascript|418296|->结果->ISODate(“2012-07-14T08:14:00.201Z”)|418297|现在只需像这样使用查询：|418298|+collection.find(+{+query+:+query+,$orderby+:{start_date+:+-1}}+,function+(err,+cursor)+{...}|418299|就是这样:)|418300|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|X|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

if your date format is like this : 14/02/1989 ----> you may find some problems 

you need to use ISOdate like this :

<pre><code>var start_date = new Date(2012, 07, x, x, x); 
</code></pre>

-----> the result ------>ISODate("2012-07-14T08:14:00.201Z")

now just use the query like this :

<pre><code> collection.find( { query : query ,$orderby :{start_date : -1}} ,function (err, cursor) {...}
</code></pre>

that's it :)

blocks|key|200178|text|在使用mongoose时，我无法使用'+toArray+'，并收到错误：TypeError:+Collection.find(...).sort(...).toArray+is+not+a+function.+toArray函数存在于本地MongoDB+NodeJS驱动程序(reference)的游标类上。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|200179|sort只接受一个参数，所以你不能在里面传递你的函数。|200180|这对我很有效(正如Emil回答的那样)：|200181|collection.find().sort('-date').exec(function(error,+result)+{
++//+Your+code
})|code-block|syntax|javascript|200182|entityMap|0|LINK|mutability|MUTABLE|url|https://mongodb.github.io/node-mongodb-native/api-generated/cursor.html#toarray|1|https://stackoverflow.com/a/33223694/7145177^0|10|1W|3U|9|0|0|0|9|4|1|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|6|7|14|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|J|3|K|5|L|7|19|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

With mongoose I was not able to use 'toArray', and was getting the error: <code>TypeError: Collection.find(...).sort(...).toArray is not a function.</code>
The toArray function exists on the Cursor class from the Native MongoDB NodeJS driver (<a href="https://mongodb.github.io/node-mongodb-native/api-generated/cursor.html#toarray" rel="nofollow noreferrer">reference</a>).

Also sort accepts only one parameter, so you can't pass your function inside it.

This worked for me (as answered by <a href="https://stackoverflow.com/a/33223694/7145177">Emil</a>):

<pre><code>collection.find().sort('-date').exec(function(error, result) {
 // Your code
})
</code></pre>

I am using MongoDB with Node.JS. I have a collection which contains a date and other rows. The date is a JavaScript <code>Date</code> object.

How can I sort this collection by date?

How to sort a collection by date in MongoDB?

MongoDB

我在Node.JS中使用MongoDB，我有一个包含日期和其他行的集合。日期是一个JavaScript Date对象。如何按日期对此集合进行排序？

问如何在MongoDB中按日期对集合进行排序？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MongoDB中按日期对集合进行排序？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MongoDB中按日期对集合进行排序？
EN