Strapi datetime configuration

Questions and Answers
1

Hi all, I was having problems working with dates in strapi. In postman I send a range from 00:00:00:00 to 23:59:59 to get all the queries registered that day; and I know that in my database I only have a query registered for the 6th of December at 22:00:00:00 to 23:00:00:00; but for some reason strapi retrieves the data with 3 additional hours, from 22:00 it jumps to 01:00 and from 23:00 to 02:00 the next day, breaking with the logic I’m handling.

Is there a timezone setting or something I am ignoring?

Thank you.

            const dateSince = new Date(ctx.request.body.dateSince);
            const dateUntil = new Date(ctx.request.body.dateUntil);
            console.log(dateSince); // '2023-12-06T00:00:00.000Z'
            console.log(dateUntil); //'2023-12-06T23:59:59.000Z'

//retrieve the records of that day
                        const consultationConsultingRoomsThisDay = await strapi.db.query('api::consultation-consulting-room.consultation-consulting-room').findMany({
                            where: {
                                since: { $gte : dateSince},
                                until: { $lte : dateUntil},
                            }, 
                            populate : true
                        });

                        console.log(consultationConsultingRoomsThisDay); // []

                        const consultationConsultingRoomsThisDay2 = await strapi.db.query('api::consultation-consulting-room.consultation-consulting-room').findMany({ 
                            populate : true
                        });
                        console.log(consultationConsultingRoomsThisDay2); //  [{  id: 1, since: '2023-12-07T01:00:00.000Z',  until: '2023-12-07T02:00:00.000Z' }]