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.)
http://dev.mysql.com/doc/refman/5.5/...erator_between
__________________
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.
|