debug query

[esthera]

i am trying to run an sql as follows

SELECT * from customer WHERE mytimestamp BETWEEN '2005-01-04' AND '2005-08-01' order by name

I am getting no records

There are clearly records for example on 2005-11-16 21:21:33 and in the format I just posted (that's how i see it in phpmyadmin.)
Ahat am i doing wrong?

[Rich Pedley]

for starters 2005-11-16 isn't inside the time frame you are looking at!