7

So I have this field called task_time stored as string in Mongodb in 'YYYY-MM-DD' format (eg. '2012-12-21').

Now I need to query this collection to get the data whose task_time is within a given time interval.

The time interval is given as a pair of strings that represent start time and end time in 'YYYY-MM-DD hh:mm:ss' format (eg. '2015-12-21 16:00:00').

Is there any way to do this directly in Mongo query without bringing this task to my javascript code?

delsin
  • 313
  • 4
  • 12

1 Answers1

12

As I know $gte and $lt can work with strings too. The same in mongoose after this issue

items.find({
    task_time: {
        $gte: "2015-12-21 12:00:00",
        $lt: "2015-12-21 16:00:00" 
    }
})
Manasov Daniel
  • 1,348
  • 9
  • 17