SELECT * FROM yourtable WHERE datcol BETWEEN '2005-01-25' AND '2005-07-31'