Sequelize Query 以查找落在日期范围内的所有记录 [英] Sequelize Query to find all records that falls in between date range
本文介绍了Sequelize Query 以查找落在日期范围内的所有记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个带列的模型:
from: { type: Sequelize.DATE }
to: { type: Sequelize.DATE }
我想查询 from
或 to
落在日期范围之间的所有记录:[startDate, endDate]
I want to query all records whose either from
OR to
falls in between the date ranges : [startDate, endDate]
尝试过类似的东西:
const where = {
$or: [{
from: {
$lte: startDate,
$gte: endDate,
},
to: {
$lte: startDate,
$gte: endDate,
},
}],
};
类似的东西:
SELECT * from MyTable WHERE (startDate <= from <= endDate) OR (startDate <= to <= endDate
推荐答案
对我有用的解决方案是:-
The solution which works for me is this:-
# here startDate and endDate are Javascript Date object
const where = {
from: {
$between: [startDate, endDate]
}
};
要了解有关运算符的更多信息:- http://docs.sequelizejs.com/en/latest/docs/querying/#operators
For reference to know more about operators:- http://docs.sequelizejs.com/en/latest/docs/querying/#operators
注意:在 MYSQL between
比较运算符是 inclusive,这意味着它等价于表达式 (startDate <= from AND from <= 结束日期)
.
Note:
In MYSQL between
comparison operator is inclusive, which means it is equivalent to the expression (startDate <= from AND from <= endDate)
.
这篇关于Sequelize Query 以查找落在日期范围内的所有记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文