... WHERE ClearDate >= '2003/03/20 0:00' AND < '2003/03/21 0:00' ...
#or express this with a between clause