Find non-ISODate records in MongoDb

Asked Aug 15 '17 at 18:31

Active Aug 15 '17 at 18:55

Viewed 782 times

I have a Mongo collection that stored a date field as a string. I ran the query below to convert this field into an ISODate, but it failed. However, there are quite a few records that now show as an ISODate.

How do I query to find all documents that are an ISODate format and all documents that are still a string?

db.TestCollection.find({}).forEach(function(doc) {
    doc.LastUpdated = new Date(doc.LastUpdated );

    db.TestCollection.save(doc);

    });

The original question has been answered, but the follow up question is: Is there a way to aggregate the type of data present in the column? I would like to return a count of each type of data in the column. I have seen type string and type date, but want to verify there isn't any other data types.

Here's roughly what I have tried:

db.TestCollection.aggregate([{
    $project: {
       LastUpdated : { $type: "$LastUpdated " }
    }
}])

edited Aug 15 '17 at 18:55

asked Aug 15 '17 at 18:31

ferensilver

See https://stackoverflow.com/a/28416864/1259510 – JohnnyHK Aug 15 '17 at 18:34
You are a life saver. Thanks! – ferensilver Aug 15 '17 at 18:38
Is there a way to aggregate them on which type? So it shows I have 100 of type String, 200 of type Date, etc.? – ferensilver Aug 15 '17 at 18:49
Something like `db.TestCollection.aggregate([{ "$group": {"_id":{"$type": "$LastUpdated"}, "count":{"$sum":1}} } ])` – s7vr Aug 15 '17 at 20:44

Find non-ISODate records in MongoDb

0 Answers0