MongoDB中 字段为数组类型的 时间比较
我有一个这样的数据
{
"_id" : ObjectId("5d3180f90bf69d240419b1aa"),
"marketName" : "安德鲁炸鸡汉堡",
"marketTimes" : [
{
"_id" : NumberLong(1029),
"time_open" : "09:00:00",
"time_over" : "22:00:00",
}
]
}
/* 2 */
{
"_id" : ObjectId("5d3180f90bf69d240419b1ab"),
"marketName" : "关爱食尚快餐",
"marketTimes" : [
{
"_id" : NumberLong(1030),
"time_open" : "09:00:00",
"time_over" : "15:00:00",
},
{
"_id" : NumberLong(1031),
"time_open" : "17:00:00",
"time_over" : "22:00:00",
}
]
}
我想获取在 marketTimes中在当前时间段的数据, 比如当前为15点30,那第二条数据就不符合条件
mongodb了解的不太多请帮助,谢谢!
原生sql语句 或者java代码都可以。