我想删除表borrowinfo中用户输入的某一个日期以前的所有记录。表中有一个日期时间型字段returndate,怎么写?
date=request.form("date")
sql="delete borrowinfo where returndate......"
set rs=conn.execute(sql)
---------------------------------------------------------------
dates=request.form("date")
delete borrowinfo where datediff('s',returndate,'"&dates&"')>0
set rs=conn.execute(sql)
---------------------------------------------------------------
dates=request("date")
sql="delete borrowinfo where datediff(s,returndate,'"&dates&"')>0"
conn.execute sql
---------------------------------------------------------------
dates=request.form("date")
sql="delete from borrowinfo where returndate <'"&date()&"'"
set rs=conn.execute(sql)