Unfortunatelly thge writer of this question (or rather the answer;>) has failed:

I've executed the example query three times and two times it returned a row (eg. when the table...

Changing the order after BETWEEN is not an issue related to DATETIME. If the question was intended to demonstrate the value of a DATETIME type without the time part then...