Hello everyone, I'm facing an issue with Sequelize where it seems to be returning the date from the backend as the day before the actual date passed. Additionally, it is adding a default time of 23:00:00. To elaborate, when a date is selected in the frontend using a datepicker and sent to the backend, it appears correctly in the Backend console. However, when used in a where clause, it shows the previous day's date along with the time stamp. For example, if the date chosen is 2020-07-11, the where clause displays 2020-07-10 23:00:00 +00:00. Is there anyone who knows how to resolve this issue? I will share the code and a screenshot from the backend console to illustrate the problem.
https://i.stack.imgur.com/ONjP5.png
var Viagem = require('../../model/viagem');
var pedido_viagem = require('../../model/pedido_viagem');
var Estado = require('../../model/estado');
var Pessoa = require('../../model/pessoa');
var Partida = require('../../model/freguesias');
var Chegada = require('../../model/freguesias');
const sequelize = require('../../model/database');
const viagem = require('../../model/viagem');
const cmv_cont = {}
sequelize.sync()
cmv_cont.pendentes_data_inicio = async(req, res) => {
const data_inicio_filtragem = req.query;
console.log(data_inicio_filtragem.data_inicio);
const data = await Viagem.findAll({
include: [{
model: Pessoa,
attributes: ['p_nome', 'u_nome']
}],
where: [
{estado: "2"},
{pago_pela_cmv: "0" },
{data_viagem: "" + data_inicio_filtragem.data_inicio }],
order: [
['data_viagem', 'ASC']
],
})
.then(function(data) {
return data;
})
.catch(error => {
console.log('Erro: ' + error);
return error;
});
res.json({ success: true, data: data });
}
module.exports = cmv_cont;