Question

144

Possible to compare date strings in mongodb?

rated 0 times [ 148] [ 4] / answers: 1 / hits: 16090 / 10 Years ago, thu, march 20, 2014, 12:00:00

I have a collection that contains documents with a date attribute like so:

{

   title: whatever,

   created: ISODate(2013-05-27T03:36:50Z)

}

I would like to select records that were created on a certain day. I was hoping I could use toDateString() and compare the values but when I do a search like the one below:

db.myCollection.find({ 'created.toDateString()': new Date('05/27/2013').toDateString() }).pretty()

But this does not work. Is there any way to do what I am attempting above?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

estefanib

Add To Favorites

Follow

Total Points: 508

Total Questions: 104

Total Answers: 83

Location: Lebanon

Member since Sun, Aug 2, 2020

4 Years ago

estefanib questions

1 JavaScript - wait until element loaded on website using Chrome extension

Sat, Jul 10, 21, 00:00, 3 Years ago

1 How to auto close an alert after few seconds with Bootstrap?

Mon, Jun 28, 21, 00:00, 3 Years ago

1 What is the difference between a User and a GuildMember in discord.js?

Sun, Sep 20, 20, 00:00, 4 Years ago

1 react styled components style inner elements

Fri, Aug 21, 20, 00:00, 4 Years ago

1 How to automatically refresh an interactive grid after clicking on save button or at a fixed interval?

Wed, Jun 17, 20, 00:00, 4 Years ago

View All

answered 10 Years ago angelr · Accepted Answer

If you want to select records then use a date range:

db.collection.find({

    created: { $gte: new Date(2013-05-27), $lt: new Date(2013-05-28) }

})

And that selects all the contained hours, minutes etc, falling between the two dates.

So you should be trying to use the date values and not coerce into strings.

If you want this for doing aggregation or otherwise need the results in a day only format then do this using $project and the date operators:

db.collection.aggregate([

    // Still match on the normal date forms, this time whole month

    { $match: {

        created: { 

           $gte: new Date(2013-05-01), 

           $lt: new Date(2013-05-31) 

        }

    }},



    // Project the date

    { $project: {

        date: {

            year  : { $year  : $created },

            month : { $month : $created },

            day:  : { $dayOfMonth: $created }

        },

        title: 1

    }},



    // Group on day and title

    { $group: {

        _id: {

            date  : $date,

            title : $title

        },

        count: { $sum: 1 }

    }},



    // Sort by date

    { $sort: { 

        _id.date.year: 1,

        _id.date.month: 1,

        _id.date.day: 1,

    }},



    // Project nicer dates and document

    { $project: {

        _id: 0,

        date: { $concat: [

            { $substr: [ $_id.date.year, 0, 4 ] },

            -,

            { $substr: [ $_id.date.month, 0, 2 ] },

            -,

            { $substr: [ $_id.date.day, 0, 2 ] }

        ]},

        title: $_id.title,

        count: 1

    }}

])