F fox_h Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-05 #1 我想把大于20天的记录从数据库中删出,怎么计算??急盼解答!!!
F fastest2000 Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-05 #2 delete from table1 where date_fld<dateadd(day,20,getdate())
L lovefox Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-06 #3 呵呵,你可以把读入的时间数据--字符型的转换成整形,然后进行简单的运算。 找出这些数据记录,第二步delete from table1 where date_fld
U urus Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-06 #4 set result=conn.execute("delete from XXXX where date_fld<"&TranslateDateTime(DateAdd("d",-20,date)))
set result=conn.execute("delete from XXXX where date_fld<"&TranslateDateTime(DateAdd("d",-20,date)))