I have a query like this:
SELECT * FROM Cases WHERE created_at BETWEEN '2020-05-01' AND '2020-05-08'
But this gives no results even though there is data on the 1st.
created_at looks like 2020-05-01 13:15:9, I suspect it has to do with the time? How could this be resolved?
It works just fine if I do larger date ranges, but it should (inclusive) work with a single date too.