0

請問可以查詢 Document 中的字串欄位, 以日期區間查詢嗎?
案例如下:
db.lab02.insert({“sdate”:”2016-11-01T07:59:56.768+08:00″,”edate”:”2016-11-01T08:01:56.768+08:00″,”val”:1});
db.lab02.insert({“sdate”:”2016-11-02T07:59:56.768+08:00″,”edate”:”2016-11-02T08:01:56.768+08:00″,”val”:3});
db.lab02.insert({“sdate”:”2016-11-03T07:59:56.768+08:00″,”edate”:”2016-11-03T08:01:56.768+08:00″,”val”:5});
db.lab02.insert({“sdate”:”2016-11-04T07:59:56.768+08:00″,”edate”:”2016-11-04T08:01:56.768+08:00″,”val”:7});
db.lab02.insert({“sdate”:”2016-11-05T07:59:56.768+08:00″,”edate”:”2016-11-05T08:01:56.768+08:00″,”val”:9});
db.lab02.insert({“sdate”:”2016-11-06T07:59:56.768+08:00″,”edate”:”2016-11-06T08:01:56.768+08:00″,”val”:11});
查詢 sdate 在 2016-11-02 至 2016-11-04 之間的資料, 有辦法查詢嗎?