Convert datetime to date of a column in where condition using sequelize

Question

Okay,

I want to convert column datetime to date while querying.

Can anyone help me out with sequelize query of below given query ?

select * from ev_events where DATE(event_date) <= '2016-10-10'

Answer 1

You can use sequelize.fn:

Event.findAll({
  where: sequelize.where(sequelize.fn('date', sequelize.col('event_date')), '<=', '2016-10-10')
})

I've had to guess how you have defined your model.