SQL Server : Query on date and HQL

Date format is 'YYYY-MM-DD'

e.g.

select * from orders where Date='2008-04-22'

HQL (as literal)

from Activity a where a.Date between '2008-01-01' and '2008-02-29'