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: 833 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.