34,592
社区成员
发帖
与我相关
我的任务
分享
declare @year int
set @year=2013
select DATEDIFF(DD,LTRIM(@year)+'-'+'11-02',getdate()) as days
days
--------
23
select Datediff(dd,convert(date,convert(varchar,DATEPART(yy,getdate()))+'-'+'11-20'),getdate())
select datediff(day,datename(year,getdate())+'-'+'11-20',GETDATE())
select datediff(day,datename(year,getdate())+'-11-20',GETDATE())
/*
5
*/