How to check if input date exists between two date columns? Nodejs sequel
P粉2376895962024-03-30 23:52:55
0
1
415
The date entered by the user is to check whether the date is between or exists between the start_Date column and the end_Date column of the MySQL database. Using NodeJS
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
If you use Sequelize for this type of query, you can use the
Op.gteandOp.lteoperators to achieve these two comparisons:const records = model.findAll({ where: { start_Date: { [Op.lte]: date }, end_Date: { [Op.gte]: date }, } })