按日期范围查询 Sequelize 中的列字段 [英] Query by Date Range for a column field in Sequelize

问题描述

我正在尝试使用 Sequelize 查询数据库以获取在特定日期范围内创建的项目.我使用了 $between 运算符，但似乎什么也没得到.

I'm trying to query a database with Sequelize to get items that were created between a certain date range. I used the $between operator but I don't seem to be getting anything.

{ 其中:{"createdAt":{"$between":["2018-03-31T21:00:00.000Z","2018-05-30T05:23:59.007Z"]}} }

谁能帮助我如何实现这一目标?

Can anyone help with how I can achieve this?

推荐答案

我也遇到了同样的问题，我得到了一个空数组作为响应.使用以下方法解决了问题:

I also had the same problem, I was getting empty array in response. The problem got fixed using :

const Op = Sequelize.Op;

然后使用[Op.between]如下图:

where: {
  createdAt: {
    [Op.between]: ["2018-07-08T14:06:48.000Z", "2019-10-08T22:33:54.000Z"]
  }
}

希望对你有帮助:)

这篇关于按日期范围查询 Sequelize 中的列字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！