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