What is the best way to convert a date to ISO format for MongoDB with the help of moment.js?

Question

Would someone be able to assist me with converting the date mentioned below into ISO format for MongoDB?

  var d = { storedDate: '26/06/2020 05:55:29 PM' };

I have been struggling to find the correct parameter needed to achieve the desired format. I attempted the following code snippet.

moment(d.storedDate).format("YYYY-MM-DD HH:mm Z");

Is there a way to obtain it in the form of

ISODate("2020-06-26T17:55:29.274Z")

Your guidance on this matter would be much appreciated.

Answer 1

Answer №1

By using the moment function with the appropriate date format, you can convert a stored date value to an ISO date in UTC for use with MongoDb.

Remember to specify the input date format when calling the function.

Answer 2

By using the moment function with the appropriate date format, you can convert a stored date value to an ISO date in UTC for use with MongoDb.

Remember to specify the input date format when calling the function.

Answer 3

For those looking to accurately store a Date object, consider this approach:

moment(d.storedDate, 'DD/MM/YYYY HH:mm:ss').toDate()

Avoid storing date and time values as strings; always opt for the appropriate data type.

Answer 4

For those looking to accurately store a Date object, consider this approach:

moment(d.storedDate, 'DD/MM/YYYY HH:mm:ss').toDate()

Avoid storing date and time values as strings; always opt for the appropriate data type.