mysql - Sequelize 如何比较日期的年份和月份

Question

我目前有这个代码:

Evento.findAll({
    where: db.sequelize.where(db.sequelize.fn('MONTH', db.sequelize.col('start_date')), req.body.month),
    order: ['start_date'],
    attributes: ['id', 'description', 'start_date', 'end_date', 'picture', 'status', 'place', 'text'],
    include: [{
        model: TypeEvent
    }]
}).then(events => {
    if (events) {
        res.status(200).send({
            events
        });
    } else {
        res.status(400).send({
            message: "without events"
        });
    }
});

但是我也需要咨询今年的事情，我不知道该怎么做，我已经尝试了所有方法，但我无法得到答案。

我想要的 SQL 查询:

SELECT .... FROM ... WHERE MONTH(start_date)=5 AND YEAR(start_date)=2021 ORDER BY ..

请帮帮我...

Answer 1

Evento.findAll({
    where: {
        [Op.and]: [
            Sequelize.where(Sequelize.fn('MONTH', Sequelize.col('start_date')), req.body.month),
            Sequelize.where(Sequelize.fn('YEAR', Sequelize.col('start_date')), req.body.year),
        ],
    },
    order: ['start_date'],
    attributes: ['id', 'description', 'start_date', 'end_date', 'picture', 'status', 'place', 'text'],
    include: [
        {
            model: TypeEvent,
        },
    ],
}).then((events) => {
    if (events) {
        res.status(200).send({
            events,
        });
    } else {
        res.status(400).send({
            message: 'without events',
        });
    }
});