ASP+SQL2000的日期处理

今天调用日期函数时候又出现了日期的问题.整理如下:

表单提交参数如下

<input name="SearchOrderTime" type="text" id="SearchOrderTime" maxlength="12" value="<%=Session("SearchOrderTime")%>"/>

ASP中接收参数代码如下

SearchOrderTime=trim(request("SearchOrderTime"))

SQL2000中的查询正确时间语句如下

Where DateDiff(d,OrderTime,getdate())=0"语句是参考

语法参考

Where DateDiff(d,OrderTime,'"&CDate(SearchOrderTime)&"')=0"

其他语句如:

Where DateDiff(d,OrderTime,#"&CDate(SearchOrderTime)&"#)=0"

Where DateDiff(d,OrderTime,#"&SearchOrderTime&"#)=0"

Where DateDiff(d,OrderTime,#"&FormateDateTime(SearchOrderTime,vbshortdate)&"#)=0"

Where DateDiff(d,OrderTime,#"&FormateDateTime(SearchOrderTime,vblongtime)&"#)=0"

Where DateDiff(d,OrderTime,"&FormateDateTime(SearchOrderTime,vbshortdate)&")=0"

Where DateDiff(d,OrderTime,"&SearchOrderTime,vbshortdate&")=0"

都是错误的.在网络上查询sql DateDiff 也是找了半天都找不到合适的结果

郁闷.心血来潮时候想到用单引号代替#居然就成功了