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.

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • 2.8.0-rc1
    • Legacy C++ Implementation
    • mongoexport
    • None
    • Windows 2008

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: