数据库中chubantime的格式是:2010-4-6,而schubanshijian1和schubanshijian2是通过日历控件输入的,格式是:2010-04-06,于是我用了如下代码,检索符合日期范围的数据,但是,无论输入什么日期,得出来的结果都是全部的数据。条件约束无效。请教一下,如何解决,谢谢! if schubanshijian1<>"" and schubanshijian2<>"" then
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) between '"&schubanshijian1&"' and '"&schubanshijian2&"'"
end if
if schubanshijian1<>"" and schubanshijian2="" then
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) >= '"&schubanshijian1&"'"
end if
if schubanshijian1="" and schubanshijian2<>"" then
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) <= '"&schubanshijian2&"'"
end if
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) between '"&schubanshijian1&"' and '"&schubanshijian2&"'"
end if
if schubanshijian1<>"" and schubanshijian2="" then
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) >= '"&schubanshijian1&"'"
end if
if schubanshijian1="" and schubanshijian2<>"" then
sqlstr=sqlstr&" and CONVERT(varchar(100), chubantime, 23) <= '"&schubanshijian2&"'"
end if
sqlstr=sqlstr&" and CONVERT(varchar(100), cast(chubantime as datetime), 23) between '"&schubanshijian1&"' and '"&schubanshijian2&"'"
end if
试一下
CONVERT(varchar(10), chubantime, 20)
//或者
sqlstr=sqlstr&" and chubantime between '"&schubanshijian1&"' and '"&schubanshijian2&"'"