Query only returns values after 00:00 AM

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!

Hello everyone, can anybody help me please with this one?? Thanks!!