Error: SQLITE_ERROR: no such function: YEAR

Dec 6 '22 Comments: 1 Answers: 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]: [

…

Open Full Question