Hello everyone,
I’m reaching out because this issue I’m having, obviously I’m missing something here…
I have this sentence in my query:
WHERE finished::date >= now() - interval ‘48 hours’
And, if I run the report let’s say at 15:00 08/06/2023, instead of geting values between 15:00 08/04/2023 and 15:00 08/06/2023, what I’m getting is values between 00:00 on 08/04/2023 and 15:00 on 08/06/2023. So I’m missing 9 hours of data…
Please, could anybody explain to me what I’m doing wrong?
Thanks! Regards!