Get latest MongoDB record by field of datetime

2019-01-09 11:59发布

问题:

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.

回答1:

Use sort and limit:

db.col.find().sort({"datetime": -1}).limit(1)