求一条关于日期的SQL语句

[liuyjcel]

表中有个时间字段EndTime,怎么在这个时间字段中，加5呢？
比如EndTime = 2009-4-22 怎么才可以使它成为 2009-4-27

[绝代坏坏]

http://www.cnblogs.com/skywind/archive/2008/02/22/1077777.html

[wxg22526451]

select EndTime=dateadd(d,5,EndTime) from tb

[ljhcy99]

select dateadd(dd,5,EndTime) as EndTime from tb

[tk1255270]

update tablename set EndTime = dateadd(dd,5,EndTime)

[叶子]

declare @EndTime datetime
set @EndTime='2009-4-22'
select convert(varchar(10),dateadd(d,5,@EndTime),120) as 'EndTime'

/*
EndTime
----------
2009-04-27
*/