查询一个已知时间（2010-10-11 13:27:30）后30分钟内的数据

[wangbo2312]

如题。
请问Sql语句怎么写。。小弟在这里先谢谢各位了。。。

[Talsha]

DTime=2010-10-11 13:27:30
DTime.AddMinutes(30);

[ksq2010]

code=SQL]select * from table where time between date and DATE_ADD(OrderDate,INTERVAL 30 MIN)[/code]

[ksq2010]

select * from table where time between date and DATE_ADD(OrderDate,INTERVAL 30 MIN)

[ksq2010]

select * from table where time between date and DATE_ADD(OrderDate,INTERVAL 30 MIN)

[try_best7]

[Quote=引用 4 楼 ksq2010 的回复:]
SQL code
select * from table where time between date and DATE_ADD(OrderDate,INTERVAL 30 MIN)
[/Quote]
正解

[智者知已应修善业]

http://blog.csdn.net/xianfajushi/archive/2009/11/05/4773217.aspx

[打一壶酱油]

select * from 表A where 时间 > '2010-10-11 13:27:30' and 时间 < dateadd(mi,30,'2010-10-11 13:27:30') 

到错版面了，同志

select * from 表A where 时间 > dateadd(mi,30,'2010-10-11 13:27:30') 

[wuyq11]

abs(datediff(mi,getdate,时间列)<=时间差范围
dateadd(mi,-3,date) and dateadd(mi,3,date) --相差3分钟