-
Type: Bug
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: 3.0.5
-
Component/s: mongoimport
-
None
-
Environment:Debian 7
-
Kernel Tools 8 08/28/15
Hi,
I'm working on importing data with dates before and after epoch.
I use a timestamp (ms) with $date like this :
{"date":{"$date":1287205428000}}
It works great, gives me a document like this :
{ "_id" : ObjectId("55ca240b026ec36b031a720c"), "date" : ISODate("2010-10-16T05:03:48Z") }
It also works great with negative timestamps (before epoch).
However, I ran into some timestamps that created problems.
For timestamps corresponding to dates between 1969-12-07 and 1970-01-25, mongoimport will throw this exception :
Failed: error getting extended BSON for document #0: invalid type for $date field
The document used to generate this error is :
{"date":{"$date":2136800000}}
or
{"date":{"$date":-2136800000}}
mongoimport -d test -c test --drop < date.json
Fyi, with this timetamp (juste a day after) it's working :
{"date":{"$date":2236800000}}
I didn't find any other ticket about this specific problem.
Regards