Import a date(ISODate) into MongoDB using mongoimport

Question

I have this MongoDB document. In JSON:

{
"attString":"hello World0",
"attInt":0,
"attDate":new Date("1990-7-20")
 }

How can I import this document into MongoDB using mongoimport? I have a problem with the attDate field.

This is MongoDB shell notice:

Failed: error unmarshaling bytes on document #1: unexpected ISODate format

Possible duplicate of [Mongoimport of json file](http://stackoverflow.com/questions/15171622/mongoimport-of-json-file) — Pio, Oct 13 '15 at 16:20

score 38 · Accepted Answer · edited Jan 26 '22 at 19:11

38

You have to change your date format in JSON

Either

{"attString":"hello World0","attInt":0,"attDate":ISODate("2013-11-20T23:32:18Z")}

OR

{"attString":"hello World0","attInt":0,"attDate":{"$date":"2013-11-20T23:32:18Z"}}

Hope it will help

edited Jan 26 '22 at 19:11

answered Oct 13 '15 at 16:29

Rohit Jain

I found this because I encountered a similar error. I found that `ISODate` is supported in MongoDB 3.4, but not 2.6. `$date` is supported in both. – Yongwei Wu Dec 12 '16 at 09:39
7

These solutions are not valid json... Any suggestions how to correct this? – olefrank Apr 04 '17 at 20:04
1

@olefrank Does it still work if you use `"$date"` as the key, instead of just `$date`? That would make it valid JSON. – Rafael Almeida Jul 11 '17 at 21:11
6

Yes, "$date" is recognized correctly from MongoDB and is valid JSON – Andreas Feb 07 '18 at 10:21
1

Is mandatory use `"$date"`, so `""` are mandatory. It is imported later how a `ISODate("same pattern used")` type – Manuel Jordan Apr 15 '21 at 23:00

1 Answers1