您需要显示从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;