DEV Community

Oussama Heloulou
Oussama Heloulou

Posted on

Error: SQLITE_ERROR: no such function: YEAR

0

I have an SQLite database with a table named BoxActivity. I need to query this DB to fetch records of a specific month of a year to make a report I've written the query:

BoxActivity.findAll({ attributes: [ [sequelize.fn('SUM', sequelize.col('boxActivity.quantity')), 'total_qty'] ], where: { quantity: { [Op.lt]: 0 }, [Op.and]: [

Top comments (0)