node.jsmongodbmongojs

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

  • Use sort and limit:

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