Loading...

XML

Word

Printable

JSON

Operating System:
ALL
Steps To Reproduce:
Hide

mongos> use test switched to db test mongos> db.test.save({d1:Date(), d2:ISODate()}) mongos> db.test.find().pretty() { "_id" : ObjectId("518c069cf87f2f3f9fd6daf8"), "d1" : "Thu May 09 2013 16:27:08 GMT-0400 (EDT)", "d2" : ISODate("2013-05-09T20:27:08.460Z") }

mongoexport in json mode:

mongoexport -d test -c test connected to: 127.0.0.1 { "_id" : { "$oid" : "518c069cf87f2f3f9fd6daf8" }, "d1" : "Thu May 09 2013 16:27:08 GMT-0400 (EDT)", "d2" : { "$date" : 1368131228460 } }

In --csv mode:

$ mongoexport -d test -c test --csv -f _id,d1,d2 connected to: 127.0.0.1 _id,d1,d2 ObjectID(518c069cf87f2f3f9fd6daf8),"Thu May 09 2013 16:27:08 GMT-0400 (EDT)",2013-05-09T20:27:08Z exported 1 records
Show
mongos> use test switched to db test mongos> db.test.save({d1:Date(), d2:ISODate()}) mongos> db.test.find().pretty() { "_id" : ObjectId( "518c069cf87f2f3f9fd6daf8" ), "d1" : "Thu May 09 2013 16:27:08 GMT-0400 (EDT)" , "d2" : ISODate( "2013-05-09T20:27:08.460Z" ) } mongoexport in json mode: mongoexport -d test -c test connected to: 127.0.0.1 { "_id" : { "$oid" : "518c069cf87f2f3f9fd6daf8" }, "d1" : "Thu May 09 2013 16:27:08 GMT-0400 (EDT)" , "d2" : { "$date" : 1368131228460 } } In --csv mode: $ mongoexport -d test -c test --csv -f _id,d1,d2 connected to: 127.0.0.1 _id,d1,d2 ObjectID(518c069cf87f2f3f9fd6daf8), "Thu May 09 2013 16:27:08 GMT-0400 (EDT)" ,2013-05-09T20:27:08Z exported 1 records

mongo export in csv mode doesn't export date fields with millisecond resolution as it does for json.