access 中的datetime字段怎样得到2010-01-20,该如何处理

access 中的datetime字段怎样得到2010-01-20
string strDateFrom="2010-01-20";
string strDateTo="2010-01-21";

where FormatDateTime(updatetime,0) between #" + strDateFrom + "# and #" + strDateTo + "# 


我想把updatetime 中的日期 2010-1-20 14:11:39 变为 2010-01-20

------解决方案--------------------------------------------------------
SELECT format([datefiled],'yyyy-mm-dd')
FROM yourtable;
------解决方案--------------------------------------------------------
where int(updatetime) between #" + strDateFrom + "# and #" + strDateTo + "#
------解决方案--------------------------------------------------------
sql=sql+"where Formate(updatetime,'yyyy-mm-dd') between '" + strDateFrom + "' and '" + strDateTo + "'"