sql时间相加问题.速度

[dongfang_beback]

表
id date timelimit
1 2006-06-06 7
2 2006-06-06 5


用SQL语句,根据已知时间date和期限timelimit值得到最终时间
结果如下:
id date timelimit date2
1 2006-06-06 7 2006-06-13
2 2006-06-06 5 2006-06-11

[子陌红尘]

select id,date,timelimit,dateadd(dd,timelimit,date) as date2 from 表

[jacobsan]

select *,dateadd(day,timelimit,date) as date2 from 表

[jacobsan]

子陌最近很快。。。

[子陌红尘]

declare @t table(id int,date datetime,timelimit int)
insert into @t select 1,'2006-06-06',7
insert into @t select 2,'2006-06-06',5

select id,date,timelimit,dateadd(dd,timelimit,date) as date2 from @t

/*

id date timelimit date2
----------- ----------------------- ----------- -----------------------
1 2006-06-06 00:00:00.000 7 2006-06-13 00:00:00.000
2 2006-06-06 00:00:00.000 5 2006-06-11 00:00:00.000

*/

[rookie_one]

select *,dateadd(day,timelimit,date) as date2 from 表
--------------------
dateadd(day,timelimit,date)--使列date在day级别上增加timelimit天