CODEWITHSUNDEEP
pythondatabasemongodb
user8564341
user8564341

Reputation:

Converting String to ISOdate in MongoDB using shell or Python Script?

I have date in String format and Like to convert in ISOdate format in mongoshell or custom python script to achieve this. I tried all possible commands but couldn't achieve this. I like to know how to convert String date into ISOdate in mongodb.

Upvotes: 0

Views: 1798

Answers (2)

user8564341
user8564341

Reputation:

I found the optimal solution for this later

Get into Database

use yourdatabase_name

Run this afterwards changing according to your requirement

db.YOURCOLLECION.find().forEach(function(element) {
element.DATE = new Date(element.DATE);
db.DATE.save(element);
})

Upvotes: 0

Atish
Atish

Reputation: 4435

Assuming

  • your collection name as: youCollection

  • field name to be converted from string to date: date

     var records = db.youCollection.find();
 records.forEach(function(doc) {
 var dateStr = doc.date;
 if(typeof dateStr === "string")
 {
 var date = new Date(dateStr);

 db.youCollection.update({_id: doc._id}, {$set: {date: date}})
 }})

    This will convert date of "2018-02-17T05:01:32.028Z" format to ISODate("2018-02-17T05:01:32.028Z")

Upvotes: 1

Related Questions