This blog is a record of some development issues I have faced. There may be something of use!
Date format is 'YYYY-MM-DD'
e.g.
select * from orders where Date='2008-04-22'
from Activity a where a.Date between '2008-01-01' and '2008-02-29'