Query MongoDb for a datetime value less than NOW

Question

This question addressess generating a query from C#, but how does one generate a comparision value equivalent to GetDate() (SQL Server) in MongoDB

i.e. I would like to express a JSON query like this:

{
Expiration: {$lte:  Now())},
}

Answer 1

Use the Javascript function new Date():

db.collection.find({ Expiration: { $lte: new Date() } })

The Mongo shell is just a Javascript shell, so you can, in principle, use any Javascript method.