请问SQL语言中日期类型字段怎么比较？

[idoloveyou]

表test中有一个time字段是日期类型，里面存放着创建这条记录的时间
现在想select出所有time在5天以前的所有记录，怎么写？

[welyngj]

select * from tablename where DATEDIFF(day, time, getdate())>5

[sshh119]

八日期分解了，date-5天再组合

[ysycrazy]

select * from test where time<dateadd(day,-5,getdate())

[sdhdy]

select * from test where time<dateadd(dd,-5,getdate())

[shuiniu]

select * from test where time < getdate() - 5
or
select * from test where time < cast(convert( char(10),getdate(),121) as datetime) - 1

[shuiniu]

笔误:
select * from test where time < cast(convert( char(10),getdate(),121) as datetime) - 5