{"id":929,"date":"2022-08-30T15:09:32","date_gmt":"2022-08-30T15:09:32","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/09\/displaying-dates-from-mongodb-with-express-js-closed-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:09:32","modified_gmt":"2022-08-30T15:09:32","slug":"displaying-dates-from-mongodb-with-express-js-closed-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/displaying-dates-from-mongodb-with-express-js-closed-collection-of-common-programming-errors\/","title":{"rendered":"Displaying Dates from MongoDB with Express.js [closed]-Collection of common programming errors"},"content":{"rendered":"

I saved few datasets to MongoDB using mongoose.js. But I got a problem with displaying them on an html site using express.js and ejs.<\/p>\n

Here is my scenario:<\/p>\n

Model<\/strong><\/p>\n

var mongoose = require('mongoose');\n\nvar Schema = mongoose.Schema;\nvar ObjectId = Schema.ObjectId;\n\nvar ItemSchema = new Schema({\n    _id: ObjectId,\n    creationTime: Date,\n    modificationTime: Date,\n    title: String\n});\nvar Item = mongoose.model('item', ItemSchema);\nmodule.exports.Item = Item;\n<\/code><\/pre>\n
Route:<\/strong><\/p>\n
app.get('\/item\/:id', function(req, res) {\n\n    Item.findById(req.params.id, function(err, doc){\n\n        console.log(doc); \/\/This check displays everything correctly on console\n\n        res.render('item.html.ejs', {\n            item : doc\n        });\n    });\n});\n<\/code><\/pre>\n
View:<\/strong><\/p>\n
:<\/code><\/h1>\n
\n
Creation: \n
Modification: \n<\/pre>\n
The result of this setting is that title is being displayed correctly while both dates are undefined<\/code>.<\/code><\/p>\n
I assume it has something to do with MongoDB’s ISODate format. But I can’t find a solution on how to convert it for displaying in html views.<\/p>\n
I appreciate your help. Cheers<\/p>\n
    \n
  1. \n
    If you just copied and pasted the code the solution is very very simple.<\/p>\n
    In your model you defined creationTime<\/code> and modificationTime<\/code> in your template you try to access item.creationDate<\/code> and item.modificationDate<\/code>.<\/p>\n
    After that change you should be able to see something other then undefined, but you probably still need to convert this into a proper date format.<\/p>\n<\/li>\n
  2. \n
    I have the following helpers using moment.js in my projects.<\/p>\n
    date: function(date){\n  moment(date).format('YYYY-MM-DD hh:mm:ss');\n},\nfromNow: function(date){\n  moment(date).fromNow()\n}\n<\/code><\/pre>\n<\/li>\n
  3. \n
    I add an ejs filter using the example above, but I had to change it a little bit to get it to work:<\/p>\n
    Create the ‘created_at’ attribute on the mongoose schema and automatically create it on save():<\/p>\n
    var ItemSchema = new Schema({\n    name    : { type: String, required: true, trim: true }\n  , created_at    : { type: Date }\n});\n\n\nItemSchema.pre('save', function(next){\n  if ( !this.created_at ) {\n    this.created_at = new Date;\n  }\n  next();\n});\n<\/code><\/pre>\n
    Install moment (and write to package.json)<\/p>\n
    npm install moment --save\n<\/code><\/pre>\n
    Add the filter in app.js or wherever else you define filters for ejs:<\/p>\n
    var moment = require('moment');\n\nejs.filters.fromNow = function(date){\n  return moment(date).fromNow()\n}\n<\/code><\/pre>\n
    Use the filter in page.ejs<\/p>\n
    \n<\/code><\/pre>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-09 22:59:29. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    I saved few datasets to MongoDB using mongoose.js. But I got a problem with displaying them on an html site using express.js and ejs. Here is my scenario: Model var mongoose = require(‘mongoose’); var Schema = mongoose.Schema; var ObjectId = Schema.ObjectId; var ItemSchema = new Schema({ _id: ObjectId, creationTime: Date, modificationTime: Date, title: String }); […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=929"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/929\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}