如何知道某时间段有多少天?

[想飞的狼]

有一个变量@t='20040428'
想知道从@t到04年底有多少天?

[wzy_love_sly]

declare @star datetime,@end datetime
set @star='2007-12-10 09:51:02.170'
set @end='2007-12-25 09:51:02.170'
select datediff(dd,@star,@end)

15

[leo_lesley]

declare @t varchar(20)

set @t='20040428'
select datediff(day,cast(@t as datetime),'2005-01-01')

[wzy_love_sly]

declare @star datetime,@end datetime
set @star='20071225'
set @star=convert(varchar(10),@star,12)
select datediff(dd,@star,cast(cast(datepart(yy,@star)+1 as varchar(10))+'-01-01' as datetime)-1)

[dawugui]

declare @t as datetime
set @t = '20040428'

select 天数 = datediff(day , @t , '2004-12-31')
select 加修正值的天数 = datediff(day , @t , '2004-12-31') + 1

/*
天数
-----------
247

(1 行受影响)

加修正值的天数
-----------
248

(1 行受影响)
*/

[dawugui]

[code=SQL]declare @t as datetime
set @t = '20040428'

select 天数 = datediff(day , @t , '2004-12-31')
select 加修正值的天数 = datediff(day , @t , '2004-12-31') + 1

/*
天数
-----------
247

(1 行受影响)

加修正值的天数
-----------
248

(1 行受影响)
*/

[/code]

[wzy_love_sly]

declare @star datetime,@end datetime
set @star=getdate()
set @star=convert(varchar(10),@star,12)
select '元旦'=datediff(dd,@star,cast(cast(datepart(yy,@star)+1 as varchar(10))+'-01-01' as datetime)-1)

元旦
6

[gimse7en]

学习~