Breaking News: Grepper is joining You.com. Read the official announcement!

convert mongodb createdAt to date

Real Rabbit answered on October 27, 2022 Popularity 9/10 Helpfulness 4/10

answer convert mongodb createdAt to date

related Converting From String to Date (MongoDB Shell)

convert mongodb createdAt to date

Comment

var createdAt = "2020-03-30T12:44:20.221+00:00"
var date = new Date(createdAt)
console.log(date.getDate() +  " " + date.toLocaleString('default', { month: 'long' }) + " " + date.getFullYear())

// Or even more concise (Thanks @RobG)
console.log(date.toLocaleString('en-GB', {day:'numeric', month: 'long', year:'numeric'}))
 Run code snippet

Popularity 9/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: to-date whatever

Link to this answer
Share Copy Link

Contributed on Oct 27 2022

Real Rabbit

0 Answers Avg Quality 2/10

Closely Related Answers

Converting From String to Date (MongoDB Shell)

Comment

// Connect to the "catalogue" database
use catalogue;

// Define an aggregation pipeline to convert the "date" field from a string to a date object
let pipeline = [
    {
        $addFields: {
            convertedDate: {
                $toDate: "$date"
            }
        }
    }
];

// Use the aggregate command to convert dates for all documents
db.products.aggregate(pipeline).forEach(function(doc) {
    // Update the original document with the converted date
    db.products.updateOne(
        { _id: doc._id },
        { $set: { date: doc.convertedDate } }
    );
});

Popularity 7/10 Helpfulness 4/10 Language whatever

Source: Grepper

Tags: string whatever to-date

Link to this answer
Share Copy Link

Contributed on Feb 10 2024

Lazy Sloth

0 Answers Avg Quality 2/10

convert mongodb createdAt to date

Contents

More Related Answers

convert mongodb createdAt to date

Closely Related Answers

Converting From String to Date (MongoDB Shell)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.