How to check if input date exists between two date columns? Nodejs sequel

Question

The date entered by the user is to check if the date is between or exists between the start_Date column and the end_Date column of the MySQL database. Using NodeJS

P粉547170972 · Answer

If you use Sequelize for this type of query, you can use the Op.gte and Op.lte operators to achieve these two comparisons:

const records = model.findAll({
  where: {
    start_Date: {
      [Op.lte]: date
    },
    end_Date: {
      [Op.gte]: date
    },
  }
})