34,838
社区成员




时间戳
------------------
01 1 2008 6:00AM
01 2 2008 6:00AM
01 3 2008 6:00AM
01 4 2008 6:00AM
01 5 2008 6:00AM
01 6 2008 6:00AM
01 7 2008 6:00AM
01 8 2008 6:00AM
01 9 2008 6:00AM
01 10 2008 6:00AM
12 29 2007 6:00AM
12 30 2007 6:00AM
12 31 2007 6:00AM
如何查出二天前的记录?
这样?
select * from @t where datediff(dd,time,getdate())>2
select * from [Table] where dateadd(day,2,时间戳)<getdate()
--两天前
select * from tb where datediff(day,2,时间戳) >= 2
--48小时前
select * from tb where datediff(hour,48,时间戳) >= 48