Query a Timestamp in MongoDB

Question

MongoDB document sample is given below:

{
    "_id" : ObjectId("5f2df113bdde22f1043g45gg"),
    "cd" : 1395376406,
    "dob" : 552026006,
    "e" : "[email protected]",
    "g" : "M"   
}

I need query to get birthday list for today using dob(date of birth) field(timestamp).

Thanks in advance!

Amit Dubey · Accepted Answer · 2014-11-20 04:37:19Z

1

I am not sure how elegant my solution is, but it should work

var start = new Date();
start.setHours(0,0,0,0);

var end = new Date();
end.setHours(23,59,59,999);

db.collection.find({dob:{$gt:start.getTime(), $lt:end.getTime()}})

answered Nov 20, 2014 at 4:37

Amit Dubey

111 bronze badge

Sign up to request clarification or add additional context in comments.

1 Comment

Amit Dubey Over a year ago

I am assuming that you are doing this in mongo shell or using javascript

BatScream · Accepted Answer · 2014-11-20 06:38:22Z

Since MongoDb doesn't have any inbuilt functions/operations to support parsing raw timestamps and extracting information from them, you need to do the operation by passing a custom java script function to the server and get it executed there. This function would be executed for each record though.

db.collection.find({$where:function(){
      var recDate = new Date(this.dob);
      var recDay = recDate.getDate();
      var recMonth = recDate.getMonth();

      var today = new Date();
      var todayDate = today.getDate();
      var todayMonth = today.getMonth();

    return (recDay == todayDate && recMonth == todayMonth);
}});

The function simply checks if any record's day and month match today's day and month. Although this works for timestamps, you should take advantage of MongoDBs ISODate data type whenever you store date information. This enables us to use various operators and functions on these fields. Moreover they would be faster. If your document had the below structure:

{
    "_id" : "1",
    "cd" : 1395376406,
    "dob" : ISODate("2014-11-19T08:00:00Z"),
    "e" : "[email protected]",
    "g" : "M"   
}

Where, the dob field is of ISODate type. You could easily do a aggregate operation to fetch the results.

var todayDate = ISODate().getDate();
var todayMonth = ISODate().getMonth();

db.collection.aggregate([
{$project:{"day":{$dayOfMonth:"$dob"},
           "month":{$month:"$dob"},
           "_id":1,"cd":1,"dob":1,"e":1,"g":1}},
{$match:{"day":todayDate,"month":todayMonth}},
{$project:{"cd":1,"dob":1,"e":1,"g":1,"_id":1}}
])

The above operation utilizes the functions and operations that are allowed on a ISODate field. Querying becomes a lot easier and better.

Collectives™ on Stack Overflow

Query a Timestamp in MongoDB

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related