JavaScript - How to save a date in MongoDB document in ISODate format?

Question

I have been trying to save the date from javascript side into MongoDB in ISODate format. But it just saves the date field in my MongoDB document in string format.

Here is the object I'm sending into the MongoDB to be saved as a document in a given collection.

var currentDate = new Date();

postData = {
   deviceID: deviceID,
   companyID: companyID,
   userID: userID,
   date: currentDate
};

Everything works fine except the date field is just saved in String format. Couldn't find any SO question which could give a clear answer for this problem as well, if there is a one please direct me to the proper place!

Sailer

This may help #21287099 – Annaleeannaliese

Answer 1

I solved this by handling this in my Node JS API side. The real problem is I've been sending this to the API as an stringified JSON object. though it was set as a new Date() object it get stringified.

So within my Node JS API side before inserting it into the MongoDB collection I've done this,

var data = req.body.postData;
var date = data[0].date;
var dateObject = new Date(date);
date[0].date = dateObject;

Which did the trick! Thanks for the answers!

Sailer

Answer 2

You can try this:

var currentDate = new Date();

postData = {
   deviceID: deviceID,
   companyID: companyID,
   userID: userID,
   date: currentDate.toISOString()
};

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toISOString

Longcloth

Thanks for the comment, but I tried this too. It still the same, just a String is being saved as the date field. – Sailer

@RavinduFernando hmm... ok. I guess then the question is a bit different then how I read it. I am not familiar with mongo internals, but accepted answer to this question may indicate that what you see is not exactly what is stored: #10908659 – Longcloth

May thanks for the point - But I also went through that answer before. but the real problem is I want do Mongo DB grouping based on the date value, but since its not in date type the Mongo DB grouping doesn't work as expected. But when I updated the field value using Robo Mongo client as ISODate and convert date field to Date type the grouping works fine. That's why I really wants to find a way which I can save the date straight in ISODate format. – Sailer