query.andWhere('cm.time >= :startTime AND cm.time <= :endTime', {
startTime: '2021-05-31 00:00:00'
endTime: '2021-05-31 23:59:59'
});
let startTime = DateTime.now().setZone('Europe/Athens').startOf('day');
let endTime = DateTime.now().setZone('Europe/Athens').endOf('day');
{ startTime: '2021-05-31T00:00:00.000+03:00' }
{ endTime: '2021-05-31T23:59:59.999+03:00' }
console.log(startTime.setZone('utc').toISO({ includeOffset: false }));
console.log(endTime.setZone('utc').toISO({ includeOffset: false }));
2021-05-30T22:00:00.000
2021-05-31T21:59:59.999