7,714
社区成员
发帖
与我相关
我的任务
分享
sql = "Select * FROM new2010year where 1=1 and FormatDateTime(b_levetime,2)=#"&b_levetime&"# order by id desc"
response.write("sql="+sql)
sql=Select * FROM new2010year where 1=1 and FormatDateTime(b_levetime,2)=#2010-01-06# order by id desc
,把输出的SQL语句在access数据库中运行,没有问题,sql="Select * FROM [new2010year] where 1=1 and Format([b_levetime],'YYYY-MM-DD')='2010-01-06' order by id desc"
<%
dim conn
set conn = server.createobject("ADODB.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+server.MapPath(database)+";"
%>
Select * FROM new2010year where 1=1 and Format(b_levetime,'YYYY-MM-DD')='2010-01-06' order by id desc