mongo查找有关joda datetime的查询

问题描述

我正在尝试使用mongodb中的find查询来确定该特定日期的记录，当我将其传递给正常日期对象并且如果我根据dateCreated字段进行查找时，该查询工作正常，但是对于joda date字段，我不知道我应该如何安排乔达约会

i am trying to use find query in mongodb to determine the records on that specific date , the query is working fine when i pass it the normal date object and if i find according to dateCreated field, but for joda date field, i don't know how should i form a joda date

现在我正在使用此查询进行常规记录

right now i am using this query for normal records

var from =  new Date('2015-05-18T00:00:00.000Z'); 
var to =  new Date('2016-05-19T00:00:00.000Z'); 
db.delivery.find( {"dateCreated" : { $gte:from,$lt:to } } );

现在我还有一个名为deliveryDate的字段，其类型为joda date并按如下方式存储

now i also have a field called deliveryDate which is of type joda date and stored like this

"deliveryDate" : {
    "jodaType" : "org.joda.time.DateTime",
    "interval_start" : ISODate("2015-03-28T18:30:00Z"),
    "interval_end" : ISODate("2015-03-28T18:30:00Z"),
    "jodaField_zone" : "UTC",
    "time" : NumberLong("1427567400000"),
    "jodaField_dayOfMonth" : 28,
    "jodaField_hourOfDay" : 18,
    "jodaField_minuteOfHour" : 30,
    "jodaField_millisOfSecond" : 0,
    "jodaField_monthOfYear" : 3,
    "jodaField_year" : 2015
},

我在Google上搜索了很多，但没有成功，我不知道如何查询乔达日期，请帮忙！

i googled a lot but with no success, i have no idea how can i query for joda date ,please help!

推荐答案

您的joda日期被序列化为嵌套的JSON对象.您应该可以使用interterval_start

Your joda date is serialised into a nested JSON object. You should be able to query on it using interterval_start

db.delivery.find( {"deliveryDate.interval_start" : { $gte:from,$lt:to } } );

这篇关于mongo查找有关joda datetime的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！