这个删除语句该怎么写？

[rinahuang]

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

[rexsp]

dates=request.form("date")
delete borrowinfo where datediff(s,returndate,'&dates&')>0
set rs=conn.execute(sql)

[rexsp]

dates=request.form("date")
delete borrowinfo where datediff('s',returndate,'"&dates&"')>0
set rs=conn.execute(sql)

[cqfeng]

dates=request("date")
sql="delete borrowinfo where datediff(s,returndate,'"&dates&"')>0"
conn.execute sql

[fqtrnt]

你能不能写得祥细一点啊?
按给出的理解.
你试一下以下的啦!

sql = delete borrowinfo where returndate=to_date('"+date+"','dd-mm-yyyy')";

[enrico]

"delete from borrowinfo where returndate <'"&date&"'"

[fqtrnt]

应该把returndate=to_date('"+date+"','dd-mm-yyyy')";改成
returndate<to_date('"+date+"','dd-mm-yyyy')";

[chichuli_4]

dates=request.form("date")

sql="delete from borrowinfo where returndate <'"&date()&"'"
set rs=conn.execute(sql)

[chichuli_4]

sorry

dates=request.form("date")

sql="delete from borrowinfo where returndate <'"&date&"'"
set rs=conn.execute(sql

[lsrzm]

dates=request.form("date")
sql ="delete borrowinfo where returndate<(select max(return) from borrowinfo)"
conn.execute sql