Comment by adeelk93

I thought the BETWEEN boundaries are always closed. Isn’t that pretty clear?

If you’re worried about date part precision in that comparison, you can always TRUNC before you BETWEEN.