求一简单SQL语句

Question

table 中有date字段，类型为datetime,我想删除该表中当前系统日期的100天以前的数据，请问该如何写？谢谢delete from table where date??

Answer 1

delete table where datediff(dd,date,getdate())>100

Answer 2

delete from table where datediff(dd,date,getdate())<100

Answer 3

delete table where date<dateadd(day,-100,getdate())

Answer 4

delete from table
where convert(varchar(10),dateadd(dd,100,date),120)<convert(varchar(10),getdate(),120)