vc,ado,access,时间段查询 - VC/MFC / 数据库

表tab_emp中有个时间字段“tt”是DateTime类型，现查询某个时间段之间的数据：
程序如下：
====================================================================================================
  CString sql="SELECT * from tab_emp where dd between'"+beginTime+"'and'"+endTime+"'";
try{ 
mm_pRecordset.CreateInstance("ADODB.Recordset");
mm_pRecordset->Open((_variant_t)sql,
_variant_t((IDispatch*)mm_pConnection,true),
adOpenStatic,adLockOptimistic,adCmdText);
if(mm_pRecordset->adoEOF){ }
else{
while(!mm_pRecordset->adoEOF)
{
CString empName = (LPCTSTR)(_bstr_t)mm_pRecordset->GetCollect("emp_name");
CString empNo = (LPCTSTR)(_bstr_t)mm_pRecordset->GetCollect("emp_no");
mm_pRecordset->MoveNext();
}
}
mm_pRecordset->Close();
mm_pRecordset=NULL;
  }
catch (...)
{
AfxMessageBox("评价信息失败!");
}
===================================================================================
我估计是sql语句写错了，请大家看看！

---

SQL code:
select * from table where updateDate between '2009-06-07 10:52:14' and '2009-06-9'

---

CString sql="SELECT * from tab_emp