您需要显示从20XX年1月1日到20XX年12月31日雇佣的所有职员的姓名和雇佣日期。职员信息表tblEmployees包含列Name和列HireDate,下面哪些语句能完成该功能 ()
A、SELECT Name, HireDate FROM tblEmployees
B、SELECT Name, HireDate FROM tblEmployees WHERE HireDate =’2009-01-01’ OR ‘2009-12-31’
C、SELECT Name, HireDate FROM tblEmployees WHERE HireDate BETWEEN ’2008-12-31’ AND ‘2010-01-01’
D、SELECT Name, HireDate FROM tblEmployees WHERE substring(HireDate,1,4)=2009;