Sequelize not creating right query with dates

Question

I don't know, why sequelize changing the dates which I passed in arguments while creating a query?

Database => mysql

I mean that I write following query with sequelize:

Stock.findAll({
        where: {
            createdAt: {
                [Op.between]: ['2021-05-01 00:00:00', '2021-05-27 00:00:00'],
            },
        },
    })
        .then((resp) => {
            console.log(JSON.parse(JSON.stringify(resp)))
        })
        .catch((err) => console.error(err))

And sequelize creating this query -

SELECT `id`
     , `quantity`
     , `event`
     , `eventId`
     , `createdAt`
     , `updatedAt`
     , `stockItemId` 
  FROM `stocks` AS `stocks` 
 WHERE `stocks`.`createdAt` BETWEEN '2021-04-30 18:30:00' AND '2021-05-26 18:30:00';

Why sequelize changing 2021-05-01 00:00:00 to 2021-04-30 18:30:00 and 2021-05-27 00:00:00 to 2021-05-26 18:30:00?

restlessmodem · Accepted Answer · 2021-05-27 14:49:11Z

1

This happens because you have to configure the correct timezone sequelize uses to write to the database. When you initialize the configuration add e.g.

timezone: '+05:30'

answered May 27, 2021 at 14:49

restlessmodem

4684 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sequelize not creating right query with dates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related