求一句where条件满足求差的SQL语句语句

[lystan]

INT a=3；
datetime dt=datetime.Now;
数据库中表A有一个Datetime类型的字段 DT_time。
需要选择SELECT语句为：SELECT * FROM [A] WHERE ([DT_time]-dt<a) ORDER BY [ID] DESC

求满足 [DT_time]-dt<a 这个条件的这句SQL语句该怎么写呢。谢谢

[jiangshun]

declare @a int
set @a=3
select * from [A] where DT_time-getdate()<@a order by [ID]

[lystan]

顶一下。来个朋友帮忙一下

[net_xiaojian]

datediff(day,DT_time,dt)

如果写错了你去看看datediff函数。

[暴走的车轮]

[Quote=引用 3 楼 net_xiaojian 的回复:]
datediff(day,DT_time,dt)

如果写错了你去看看datediff函数。
[/Quote]


 

[sunchf]

SELECT语句为：SELECT * FROM [A] WHERE (Datediff(d,DT_time,GetDate())<a) ORDER BY [ID] DESC

[Terry717]

SELECT * FROM [A] WHERE datediff(dd, getdate(), [DT_time] ) < a ORDER BY [ID] DESC

-- or 

SELECT * FROM [A] WHERE datediff(dd, dt, [DT_time]) < a ORDER BY [ID] DESC

[Nathan_Loo]

这么简单道题。。来晚了。。楼上的对！！

[虞汶霖]

顶............

[zlb789]

来晚了 datediff 看看这个函数就OK 了