Details
-
Bug
-
Status: Closed
-
Major - P3
-
Resolution: Fixed
-
3.0.5
-
None
-
Debian 7
-
Kernel Tools 8 08/28/15
Description
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