CODEWITHSUNDEEP
mongodbsails.jssails-mongo
Tejashri Bedarkar
Tejashri Bedarkar

Reputation: 159

get records created within 24 hour in sails js

I want to fetch the Posts which are created within 24 hours in sails js. And I am using mongodb database. How do I get all those Posts which are created in past 24 hours.

Upvotes: 3

Views: 1024

Answers (1)

chridam
chridam

Reputation: 103355

You can create a date range that consists of 24 hours in the following manner.

Using the momentjs library, you can create a date with the extension methods subtract() and cast it to a JS Date with the toDate() method:

var start = moment().subtract(24, 'hours').toDate();

or with plain vanilla Date objects, create the date range as:

var now = new Date(),
    start = new Date(now.getTime() - (24 * 60 * 60 * 1000));

Use the where() method to use the query the Posts model using the above date range query, given the field which holds the timestamp is called date:

Posts.find()
    .where({ "date" : { ">": start } })
    .exec(function (err, posts) {
        if (err) throw err;
        return res.json(posts);
    });

Upvotes: 4

Related Questions