How can I project date string or object instead of date number field in mongodb find query?

Question

I have a date field that is javascript number date and I want to get the string or object of date (like new Date(date)) in find query projection instead of date field itself that is number.

//I want to get 
datetime:new Date(date)
//instead of 
db.myCollection.find({},{date:1})

thanks.

user_2282079 · Answer

You can use forEach or map function

db.yourCollectionName.find({}).map(function(doc) {
    return {
        d:new Date(doc.datetime)
        };
});

How can I project date string or object instead of date number field in mongodb find query?

1 Answers