Function extract

Example

// EXTRACT(YEAR FROM createdAt)
User.findAll({
  attributes: [[extract('createdAt', 'year'), 'year']]
})

// EXTRACT(MONTH FROM order_date)
User.findAll({
  attributes: [[extract(col('order_date'), 'month'), 'month']]
})

// Use in WHERE clause
User.findAll({
  where: {
    [extract('createdAt', 'year')]: 2024
  }
})

// Available parts: year, month, day, hour, minute, second
Copy