且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Sequelize Query 以查找落在日期范围内的所有记录

更新时间: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).