求一sql

[zq102605]

表A 字段 dDate （预定日期）
我想得到dDate在半年至一年之间的符合条件的记录

[htl258_Tony]

SELECT * FROM TABLE_NAME WHERE dDate BETWEEN '2008-07-01' AND '2008-12-31'

[guxiaoshi]

SELECT * FROM TABLE_NAME WHERE dDate BETWEEN '2008-07-01' AND '2008-12-31'

[zq102605]

我要动态获取呢，也就是当前时间是变化的不能直接用具体的日期'2008-07-01'

[jasonren]

SELECT * FROM TABLE_NAME WHERE dDate BETWEEN dateadd(year,-1,getdate()) and dateadd(month,-6,getdate()) 

[jasonren]

这里的getdate（）可以替换成你设置的标准时间。

[jiuzaishizhe]

SELECT * FROM TABLE_NAME WHERE dDate BETWEEN '2008-07-01' AND '2008-12-31'

[Dear SQL(燊)]

select * from A where dDate Between cast(left(getdate(),4)+'07/1' as datetime) and cast(left(getdate(),4)+'12/31' as datetime)

[rucypli]

create proc
 @time datetime
as
SELECT * FROM TABLE_NAME WHERE dDate BETWEEN dateadd(dd,-180,@time ) AND @time

[ziyuan_1016]

在程序里算好日期，传到SQL语句里就好了吧
假设变量名为：日期1，日期2
SQL="SELECT * FROM TABLE_NAME WHERE dDate BETWEEN '"+变量1+"' AND '"+变量2+"'"

[ChinaJiaBing]

select * from A where between DATEADD(MONTH,6,ddate) and DATEADD(YEAR,1,ddate)

[ziyuan_1016]

SELECT * FROM TABLE_NAME WHERE dDate BETWEEN dateadd(month,-6,getdate()) and getdate() order by dDate

[ziyuan_1016]

上面写的是查半年前的，理解错了，下面的是查未来半年到一年的
select * from TABLE_NAME where dDate between DATEADD(MONTH,6,getdate()) and DATEADD(YEAR,1,getdate())