Get latest MongoDB record by field of datetime
I have a collection like this:
{
'datetime': some-date,
'lat': '32.00',
'lon': '74.00'
},
{
'datetime': some-date,
'lat': '32.00',
'lon': '74.00'
}
How can I get the latest record from MongoDB, where the datetime is the latest one? I want only a single record.
Solution 1:
Use sort
and limit
:
db.col.find().sort({"datetime": -1}).limit(1)
Solution 2:
For node.js
you can use the findOne()
function:
db.collection('yourCollectionName').findOne(
{},
{ sort: { datetime: -1 } },
(err, data) => {
console.log(data);
},
);