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.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: Legacy C++ Implementation
    • Fix Version/s: 2.8.0-rc1
    • Component/s: mongoexport
    • Labels:
      None
    • Environment:
      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

            Assignee:
            mpobrien Michael O'Brien
            Reporter:
            jdulworth Jacob Dulworth
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: