Specify date format when updating date field in mongoDB document

Question

I am using mongoDB 3.4 and want to close documents in a mongoDB collection by setting an EffectiveEndDateTime field to todays/current date time and want it in this format: yyyy-MM-dd HH:mm:ss.SSS.

How can I specify the date format?

My current update query is:

db.stores.update({
    "storeID": "P0925"
}, {
    $set: {
        "EffectiveEndDateTime": Date()
    }
}, {
    "multi": true
})

Thanks

well.. AFAIK that's already the default format. – felipsmartins Jan 13 '17 at 14:10 — felipsmartins, Jan 13 '17 at 14:10

score 1 · Accepted Answer · answered Jan 13 '17 at 14:10

1

Just add new keyword to Date in your query

db.stores.update({"storeID" : "P0925"}, {$set : {"EffectiveEndDateTime": new Date()}}, {"multi" : true})

answered Jan 13 '17 at 14:10

Med Lazhari

608
5
9

Specify date format when updating date field in mongoDB document

1 Answers1