使用Sequalize运算符获取日期

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'mysql'
});

sequelize.query('SELECT CURDATE() AS currentDate', { type: Sequelize.QueryTypes.SELECT })
  .then(result => {
    const currentDate = result[0].currentDate;
    console.log('Current date:', currentDate);
  })
  .catch(error => {
    console.error('Error:', error);
  });

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'mysql'
});

const currentDate = new Date();
const sevenDaysAgo = new Date(currentDate.getTime() - 7 * 24 * 60 * 60 * 1000);

sequelize.models.ModelName.findAll({
  where: {
    createdAt: {
      [Sequelize.Op.between]: [sevenDaysAgo, currentDate]
    }
  }
})
  .then(result => {
    console.log('Data:', result);
  })
  .catch(error => {
    console.error('Error:', error);
  });