How do I format dates from Mongoose in NodeJS ?

In Mongoose, formatting dates typically involves two steps: first, specify the date field type in the schema, and then format the date output after retrieving the query results using JavaScript's built-in date methods or libraries such as Moment.js.

Step 1: Setting Date Fields in the Schema

When defining a schema in Mongoose, you can specify the Date type for date fields, as shown below:

javascript
const mongoose = require('mongoose');
const { Schema } = mongoose;

const mySchema = new Schema({
  createdAt: { type: Date, default: Date.now }
  // other fields...
});

const MyModel = mongoose.model('MyModel', mySchema);

Step 2: Formatting Date Output

When retrieving data from the database, the date field will be a JavaScript Date object. You can format it using JavaScript's built-in methods, such as toLocaleDateString or toLocaleTimeString.

javascript
MyModel.findById(someId, (err, doc) => {
  if (!err) {
    console.log(`The date is formatted as: ${doc.createdAt.toLocaleDateString('en-US')}`);
  }
});

However, for more complex date formatting, many developers choose to use libraries like moment or date-fns, which provide more formatting options and convenient syntax.

Example Using Moment.js

First, you need to install Moment.js:

sh
npm install moment

Then you can use it in your code to format the date as follows:

javascript
const moment = require('moment');

MyModel.findById(someId, (err, doc) => {
  if (!err) {
    // Format using moment
    console.log(`The date is formatted as: ${moment(doc.createdAt).format('YYYY-MM-DD HH:mm:ss')}`);
  }
});

Formatting with Virtual Properties

Mongoose also allows you to define virtual properties in the schema to provide formatted date fields without altering the data stored in the database.

javascript
mySchema.virtual('formattedDate').get(function() {
  return moment(this.createdAt).format('YYYY-MM-DD HH:mm:ss');
});

MyModel.findById(someId, (err, doc) => {
  if (!err) {
    // Access the virtual property directly
    console.log(`The date is formatted as: ${doc.formattedDate}`);
  }
});

These are some basic methods for defining and formatting dates in Mongoose. Remember that formatting dates is typically a presentation-layer operation, not at the database level, which helps maintain data consistency and flexibility.