本文介绍了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 Date objects
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 <= endDate)
.
Note:
In MYSQL between
comparison operator is inclusive, which means it is equivalent to the expression (startDate <= from AND from <= endDate)
.
这篇关于Sequelize Query 查找日期范围内的所有记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!