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
_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.