Silly me! I didn't notice before. Your two BETWEEN values are *BACKWARDS*!!!
The lower one MUST come first! (Which means earlier one in the case of timestamps.)
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.