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.
If you’re worried about date part precision in that comparison, you can always TRUNC before you BETWEEN.
Nop :) That would be my guess too, but I definitely would not be certain about it, and the dozens of people that are going to read the code won't be either, some of them might make the wrong assumption, and bad things happen. I much prefer to be explicit with `>= <=` too
I wouldn't count on every DBMS correctly implement the standard. Specifically, I would expect Oracle to have some crazy concept of "closed" on specific contexts that don't align with anybody's.
Anyway, in my opinion it shouldn't be used because the boundaries are both closed, and that's an incredibly bad choice. Even when it doesn't matter you have to go and confirm it doesn't matter.