更新时间:2022-06-27 05:53:29
对我有用的解决方案是:-
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)
.