>I got what? What you don't get is BETWEEN doesn't provide any problem with datetime values. You get what you ask for, isn't it?
>Cetin

It surely does present a problem already clearly explained. If you have hard time admitting there is a problem, I let you be and don't be surprised by incorrect results returned by your queries using BETWEEN operator when you get more records than expected or less.