timesout = dateadd("n", -1, now())
sql="delete * from zai where times < #" & timesout & "#"
conn.Execute sql
以上是在access数据库里运行正常.
现在我要改用SQL数据库要怎么改.
我是这样改的对吗?
timesout = dateadd("n", -10, getdate())
sql="delete * from zai where times < & timesout & "
conn.Execute sql
请指教.

sql="delete * from zai where times < '"&timesout&"' "

[此贴子已经被作者于2006-7-3 17:19:56编辑过]

收到谢谢