node.js - 序列化查询 where createAt 日期(例如今天的日期)

Question

在 Express 框架中，我使用 Sequelize。我想选择注册的用户的名字和姓氏与createdAt字段匹配的特定日期。我的查询如下。

const userData = models.users;
var querystring = { where: {createdAt: {[op.like]: '%2018-09-27%'}}, attributes: ['first_name', 'last_name'] }
userData.findOne(querystring).then(function (userData) {

    console.log(userData);

});

但是我在下面遇到错误......

Deprecation warning: value provided is not in a recognized RFC2822 or ISO format. moment construction falls back to js Date(), which is not reliable across all browsers and versions. Non RFC2822/ISO date formats are discouraged and will be removed in an upcoming major release. Please refer to http://momentjs.com/guides/#/warnings/js-date/ for more info. Arguments: [0] _isAMomentObject: true, _isUTC: false, _useUTC: false, _l: undefined, _i: %2018-09-27%, _f: undefined, _strict: undefined, _locale: [object Object]

提前致谢

Answer 1

可以使用日期范围查询某个日期登记了哪些人。

使用 startTime = 一天的开始，endTime = 一天的结束。

Model.findAll({
    where: {
        createdAt: {
            $gt: startTime,
            $lt: endTime
        }
    }
})