如何用sequelize查询当天数据

Question

mysql内查询的语句是

SELECT * FROM order WHERE TO_DAYS(order_time) = TO_DAYS(NOW())

请问如何用sequelize查询呢，不会语法- - 把上面的查询语句加到findAll里面的where

Answer 1

where:{ 
  $and: [
      status: '0',
      sushequ: ctx.request.body.class,
      sequelize.where(
        sequelize.fn('DATE', sequelize.col('created_at')), // 表对应的字段
        sequelize.literal('CURRENT_DATE')
      )
  ]
}