Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

Date format type is getting changed in Mongo Query DBTool

Options
Parasofttoudaya
Parasofttoudaya Posts: 232 ✭✭

Hi Team,

We have date saved in MongoDB as ISODate as shown below.
"OrderCreatedTime" : ISODate("2018-11-27T13:22:38.792+0000"),

But Mongo is giving as long numbers
"OrderCreatedTime":1205914730149

Could u please check it. We are not sure why its getting changed in MongoQueryDBTool.

Regards
Udaya

Comments

  • jakubiak
    jakubiak Posts: 798 admin
    Options

    The Mongo DB Query Tool is simply calling toJson() on each document retrieved from Mongo - I suspect that toJson() is not doing any special handling of the date but is simply returning the simple form in which the date is stored in the database.