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 + "'"