代码改变世界

sql时间查询

2009-09-24 15:46  LvSir  阅读(535)  评论(1)  编辑  收藏  举报

access

   datawhere="where ( Address like '%" & Keyword &_
             "%' or OrderNo like '%" & Keyword &_
             "%' or UserName like '%" & Keyword &_
             "%') and AddTime >= #" & StartDate & "# and AddTime <=#" & EndDate & "#"

sqlserver

   datawhere="where ( Address like '%" & Keyword &_
             "%' or OrderNo like '%" & Keyword &_
             "%' or UserName like '%" & Keyword &_
             "%') and AddTime >= '" & StartDate & "' and AddTime <='" & EndDate & "'"