Uploaded image for project: 'MongoDB Database Tools'
  1. MongoDB Database Tools
  2. TOOLS-85

When exporting a document to a csv file with MongoExport, miliseconds are being dropped from ISODate columns.

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • 2.8.0-rc1
    • Affects Version/s: Legacy C++ Implementation
    • Component/s: mongoexport
    • Labels:
      None
    • Environment:
      Windows 2008

      When running the below command, the values in datetime columns do not contain the miliseconds, but when querying the document with mongod the miliseconds value is present.

      mongoexport -vv --host server.domain:27017 --db dbname -collection exec --query "{"TransactTime":{$gt:new Date(1379030644000)}}" --csv --fields TransactTime --out C:\MongoDB\test.csv

            Assignee:
            mikeo@mongodb.com Michael O'Brien
            Reporter:
            jdulworth Jacob Dulworth
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: